--average capital gain for each occupation group where group size is at least 30
SELECT ifnull(occupation,'N/A') AS occupation, COUNT(*) as people_count, CAST(AVG (capitalgain) AS INTEGER) as avg_gain
FROM person
GROUP BY occupation
HAVING people_count>=60
ORDER BY 3 DESC;