How to write down a query for repeted value in sql

Question

Dear frnds I have a table like employee ------------------------- EID. ENAME --_----------------------- 1 A 2. B 3. C 4. A 5. B 6. C 7. A ---------------------------- I want the display like A = 3 B = 2 C = 2 How to do this