How to Use count and Group By with Self join in the same table in sql server 2008?

Question

I have a single table with columns of st_name and id. I need to get the count of st_name and Group by st_name. How do I do this?

Answer 1

select st_name, 
       count(*) as grp_cnt,
       (select count(distinct st_name) from your_table) as st_cnt
from your_table
group by st_name