Non-Correlated Subqueries III


Doesn't this do the same thing as the solution given? Why do we need a subquery in this problem?

SELECT dep_month,     dep_day_of_week,
                  AVG(distance) AS flight_distance
                 FROM flights
                GROUP BY 1,2;


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.