Case and Count in SQL Server 2008 - Stack Overflow

I have a tbale that store multiple items for a state and I want to get count for every states according ...

stackoverflow.com