4. Non-Correlated Subqueries III



Can anyone let me know if my code is correct to the example in the referred excercise

SELECT AVG(flight_count), dep_month, dep_day_of_week  FROM
(SELECT COUNT(*) AS flight_count, dep_day_of_week, dep_month FROM flights
GROUP BY dep_day_of_week, dep_month)
WHERE dep_day_of_week = 'Friday'
GROUP BY dep_month, dep_day_of_week;


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