qry09

Count of Publishers in each State

SELECT COUNT(tblPublisher_Name) AS CountofPublishers, tblPublisher_State, tblPublisher_Country
FROM tblPublisher
WHERE tblPublisher_Country = 'US'
GROUP BY tblPublisher_State
ORDER BY CountofPublishers DESC, tblPublisher_State ASC