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;