--top 3 occupations according to avg capital gain
SELECT occupation, avg (capitalgain) as avggain
FROM person
GROUP BY occupation
ORDER BY 2 DESC
LIMIT 3;