--2 histograms side-by-side
SELECT ifnull(occupation,'N/A') AS occupation, COUNT(*) AS total_people,			
       SUM(CASE WHEN salarylevel='>50K' THEN 1 ELSE 0 END) AS rich_people
FROM person
GROUP BY occupation
ORDER BY 3 DESC;