SELECT 
    state,
    COUNT(*) AS total_tracts,
    SUM(lilatracts_1and10) AS food_desert_tracts,
    ROUND(100.0 * SUM(lilatracts_1and10) / COUNT(*), 1) AS pct_food_desert
FROM food_access_raw
GROUP BY state
ORDER BY food_desert_tracts DESC;