all: More_demanded_occupation_2020

Custom SQL query returning 20 rows (hide)

select
 sum(positions_approved) approved,
  occupations
   from
     [all]
     where
     phase like '2020Q%'  
     group by occupations
     having sum(positions_approved) > 100
     order by
       approved desc
       limit 20

approvedoccupations
20855 8431-General farm workers
4412 8432-Nursery and greenhouse workers
2347 7511-Transport truck drivers
2002 9463-Fish and seafood plant workers
1657 6322-Cooks
1411 9617-Labourers in food, beverage and associated products processing
1320 6311-Food service supervisors
684 8611-Harvesting labourers
658 8612-Landscaping and grounds maintenance labourers
592 8252-Agricultural service contractors, farm supervisors and specialized livestock workers
477 7237-Welders and related machine operators
468 2173-Software engineers and designers
457 2174-Computer programmers and interactive media developers
394 6211-Retail sales supervisors
297 7611-Construction trades helpers and labourers
296 2171-Information systems analysts and consultants
292 9618-Labourers in fish and seafood processing
264 5241-Graphic designers and illustrators
262 1241-Administrative assistants
246 0631-Restaurant and food service managers
Powered by Datasette · Query took 58.673ms