How to take the count

[shaan1980]

I have a database

ID AlPHA
x A
x B
x C
y T
y Y
y N
y Q

I want to write an SQL that gives me the distinct ID and the count of column ALPHA

In this case I want the response to be

x 3
y 4

[txbakers]

select id, count(id) order by id group by id