i have 14 states in one column how to select data on the basis of different 14 states and select data on a single state in one single query

You can use a CTE to create different grouped data which you then merge. You can also group by different things in the same query by using OVER as in

select count(item1) over (group by id) as byId, count(item1) over (group by name) as byName from myTable