Non-Correlated Subqueries III


#1



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;


#2

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