I have reviewed my code with others who posted and I have the same thing but this lesson has a bug and will not let me get to next lesson?
This is getting a little frustrating as this is the second day with no support resolution...I'm kinda complaining but not really as I appreciate the best free online tutorial from Codecademy.....
"Use the Select statement to view the table"
a.dep_month, a.dep_day_of_week, AVG (a.flight_distance) AS
( SELECT dep_month,
COUNT(*) AS flight_distance
GROUP BY 1, 2, 3) a
GROUP BY 1,2
ORDER BY 1,2;