I've had all kinds of problems with this lesson, more than any other CC lesson taken so far. Not sure if it's the way the question is worded or if it's because there's a lot of code with new concepts that can be overwhelming.
For the example given, I read the question that they want us to find the average number of flights for just Fridays in a given month, but when I cut and paste the example given, it returns for every day of the week from Monday thru Sunday and from there I found myself completely lost.
I've created my own code for what I think might be a better solution? I'm not trying to say my solution is more correct than CC. There is a good chance I may be wrong. I'm simply trying to fully understand the lesson. Please help clarify if my understanding is correct. Thanks in advance for any feedback.
SELECT f.dep_month AS 'Month', f.dep_day_of_week AS 'Day of Week', AVG(f.total) AS 'Avg. Flights' FROM ( SELECT dep_month, dep_day_of_week, dep_date, COUNT(dep_day_of_week) as 'total' FROM flights WHERE dep_day_of_week = 'Friday' GROUP BY 1) f GROUP BY 1;