Count number of times value appears in particular column in MySQL

gistfile1.sql

-- Duomenys:
-- zigmas
-- zigmas
-- petras

-- Rezultatai:
-- zigmas 2
-- petras 1

select name, count(*) as n FROM orders order by n GROUP BY name