how to create ranking and order mysql table

[alapimba]

Hello

 

I have a mysql table like this:

id | user | car
1 | 1 | fiat 500
2 | 2 | vw polo
3 | 2 | vw golf
4 | 3 | renault clio
5 | 2 | fiat panda

6 | 3 | seat ibiza

From this table how can i get a query that the result be like:

 

user 2 - 3 cars

user 3 - 2 cars

user 1 - 1 cars

 

Thanks

[Psycho]

SELECT user, COUNT(car) as car_count

FROM table_name

GROUP BY user

ORDER BY car_count

Edited August 29, 2014 by Psycho