4. Non-Correlated Subqueries III


#1


https://www.codecademy.com/en/courses/sql-table-transformation/lessons/subqueries/exercises/non-correlated-iii?action=resume


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;


#2

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