Day 10 Of Learning
SELECT [Departure Station], count(*) as Total_Departure
from railway
GROUP BY [Departure Station]
HAVING COUNT([Departure Station]) > 100
ORDER BY [Departure Station] DESC
your code is good but you're aggregating the departure station when you need to aggregate the transactions
SELECT [Departure Station], count(*) as Total_Departure
from railway
GROUP BY [Departure Station]
HAVING COUNT([Departure Station]) > 100
ORDER BY [Departure Station] DESC
your code is good but you're aggregating the departure station when you need to aggregate the transactions