SELECT state_province_county ,  count(*) FROM addresses GROUP BY state_province_county
SELECT state_province_county ,  count(*) FROM addresses GROUP BY state_province_county <table_name> : Addresses col : address_id | line_1_number_building | city | zip_postcode | state_province_county | country row 1 : 1 | 4315 Kerluke Canyon Apt. 800 | Hertafurt | 740 | Nevada | USA row 2 : 2 | 319 Kozey Highway Suite 973 | Edgardoberg | 282 | Colorado | USA row 3 : 3 | 592 Frederique Ridge | Gilbertmouth | 167 | Virginia | USA row 4 : 4 | 01868 Laverna Green | Lake Floyd | 41 | Oklahoma | USA row 5 : 5 | 6017 Price Greens | Gibsonfurt | 873 | District of Columbia | USA row 6 : 6 | 037 Luella Path | North Jairo | 126 | Maryland | USA row 7 : 7 | 044 Greenfelder Fort | East Rickey | 564 | Louisiana | USA row 8 : 8 | 2676 Connelly Islands Apt. 199 | West Kaiatown | 770 | Oregon | USA row 9 : 9 | 6830 Alexanne Forks Apt. 925 | Agustinstad | 248 | Illinois | USA row 10 : 10 | 918 Lauren Drive | Gleasonland | 116 | Kentucky | USA row 11 : 11 | 70345 Marvin Glens Apt. 669 | Lake Katheryn | 505 | Kentucky | USA row 12 : 12 | 65854 McKenzie Tunnel | North Lisandroport | 202 | Maine | USA row 13 : 13 | 494 Bruen Radial Apt. 723 | Estaland | 381 | Idaho | USA row 14 : 14 | 794 Doyle Lake Apt. 531 | West Muriel | 571 | Vermont | USA row 15 : 15 | 9590 Rogahn Point Apt. 466 | Port Montytown | 37 | SouthDakota | USA
col : state_province_county | count(*) row 1 : Colorado | 1 row 2 : District of Columbia | 1 row 3 : Idaho | 1 row 4 : Illinois | 1 row 5 : Kentucky | 2 row 6 : Louisiana | 1 row 7 : Maine | 1 row 8 : Maryland | 1 row 9 : Nevada | 1 row 10 : Oklahoma | 1 row 11 : Oregon | 1 row 12 : SouthDakota | 1 row 13 : Vermont | 1 row 14 : Virginia | 1