-- Which months after 2016 had the average employment in the ‘Government’ sector in California higher than 20 million (after rounding)?
SELECT count(EXTRACT(month FROM date)) , avg(employment_1000s/1000) as avg_employment
FROM table
WHERE state = 'California' AND EXTRACT(year FROM date) > 2016 AND industry = 'Government' AND (employment_1000s/1000) > 20
Group BY EXTRACT(year FROM date)
ORDER BY avg_employment DESC