This is a part of the example code. I am quite confused by the COUNT(*). As the * means “all” in SQL, what does this * cover? Does it count all the month, week, and date? Or just the date?
SELECT dep_month, dep_day_of_week, dep_date, COUNT(*) AS flight_count FROM flights GROUP BY 1,2,3;