how to use sql count function and group by.

Question

I have table that is given below. I want to get result show on top.
Table number 1st is output and table 2 is question.

Zone Name	Area
1	3
2	1
3	2
4	3
5	1
6	1

 
 

Zone Name	Area
1	A1
1	A2
1	A3
2	A4
3	A5
3	A6
4	A7
5	A8
6	A9
4	A10
4	A11