Hey, I need a little help with this exercise. I need to find the average total distance flown by day of week and month by using sub queries. But it says that my code is wrong.
AVG(a.flight_distance) as average_distance
COUNT(*) AS flight_distance
GROUP BY 1,2,3
GROUP BY 1,2
ORDER BY 1,2;