Non-Correlated Subqueries III
My sql statement appears to be returning the right result set but I'm not being allowed to go to the next exercise. I assume I'm doing something wrong. Any help would be appreciated. Thanks..!!
SELECT a.dep_month, a.dep_day_of_week, Round (AVG(a.flight_distance)) AS average_distance FROM ( SELECT dep_month, dep_day_of_week, dep_date, AVG(distance) AS flight_distance FROM flights GROUP BY 1,2,3 ) a GROUP BY 1,2 ORDER BY 1,2;