Non-Correlated Subqueries III

#1

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;
#2

It may be a count of the rows?

#3

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