2 Comments
User's avatar
Muhammad Hussnain's avatar

SELECT [Departure Station], count(*) as Total_Departure

from railway

GROUP BY [Departure Station]

HAVING COUNT([Departure Station]) > 100

ORDER BY [Departure Station] DESC

Expand full comment
IslamabadDataGuy's avatar

your code is good but you're aggregating the departure station when you need to aggregate the transactions

Expand full comment