Non correlated iii same issue


#1

Continuing the discussion from Non-Correlated-iii:

Here is the code and I am not able to pass either?

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,
distance,
COUNT(*) AS flight_distance
FROM flights
GROUP BY 1,2,3
) a
GROUP BY 1,2
ORDER BY 1,2;


#2