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..!!
Round (AVG(a.flight_distance)) AS average_distance
AVG(distance) AS flight_distance
GROUP BY 1,2,3
GROUP BY 1,2
ORDER BY 1,2;