Couldnt figure out what the error was


#1




select a.dep_month,
a.dep_day_of_week,
avg(a.flight_distance) as average_distance
from (
  select dep_month,
    dep_day_of_week,
  dep_date,
    sum(distance) as flight_distance
 from flights
group 1, 2, 3
) a

group by 1, 2
order by 2 asc;


#2

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.