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

Count of Publishers	State
138	NY
20	MA
9	CA
9	PA
7	DC
6	IL
5	NC
5	NJ
4	CT
4	NH
4	VA
3	IN
3	KY
3	OH
3	TX
2	GA
2	KA
2	KS
2	LA
2	MD
2	MT
2	NE
2	RI
2	SC
2	WI
1	AL
1	AR
1	CO
1	FL
1	ID
1	MI
1	MN
1	MO
1	NM
1	OR
1	UT