How many establishments by state?
SELECT state, COUNT(*) AS total_establishments FROM establishment GROUP BY state;
AC, 3; AL, 13; AM, 10; AP, 5; BA, 53; CE, 25; DF, 16; ES, 22; EX, 3; GO, 34; MA, 22; MG, 112; MS, 10; MT, 17; PA, 24; PB, 16; PE, 23; PI, 5; PR, 74; RJ, 81; RN, 8; RO, 9; RR, 1; RS, 67; SC, 44; SE, 16; SP, 280; TO, 7