How do i solve the below code syntax error . . . where year = origin in (select x.origin from (with subquesry as (
Posted: Fri Jul 08, 2022 6:38 am
How do i solve the below code syntax error
<code>. . . where year = origin in (select x.origin from(with subquesry as ( select origin,year,count(*) as depdelay_countfrom ontime where depdelay > 15 group by year,origin order bydepdelay_count desc ) select origin,year,rank() over (partition byyear order by depdelay_count desc) as rank from subquesry) x wtgroup by origin order by origin;
with oy as (select origin, year,count(*) as numflights, sum( (depdelay >15)::int ) as depdelay_count, row_number() over (partition by yearorder by sum( (depdelay > 15)::int ) desc) as seqnum from ontimegroup by origin, year )select oy.* from oy where seqnum <= 10;</code>
Above is the error i am getting
thank you
<code>. . . where year = origin in (select x.origin from(with subquesry as ( select origin,year,count(*) as depdelay_countfrom ontime where depdelay > 15 group by year,origin order bydepdelay_count desc ) select origin,year,rank() over (partition byyear order by depdelay_count desc) as rank from subquesry) x wtgroup by origin order by origin;
with oy as (select origin, year,count(*) as numflights, sum( (depdelay >15)::int ) as depdelay_count, row_number() over (partition by yearorder by sum( (depdelay > 15)::int ) desc) as seqnum from ontimegroup by origin, year )select oy.* from oy where seqnum <= 10;</code>
Above is the error i am getting
thank you