Count the number of times a name appears in a column

[Celcius]

I need to count the number of times each occurrence of a name appears in a column and then list the top three values

 

SELECT name

FROM Passengers

...

LIMIT 0,3;

 

Or something like that.

[Celcius]

Sorry, I solved it.

 

 

SELECT name, COUNT(name)

FROM Passengers

GROUP BY name

ORDER BY COUNT(name)

LIMIT 0,3;