all: More_demanded_occupation_2021

Custom SQL query returning 20 rows (hide)

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

Edit SQL

approvedoccupations
51953 8431-General farm workers
10354 8432-Nursery and greenhouse workers
4643 6322-Cooks
3463 6311-Food service supervisors
3178 9463-Fish and seafood plant workers
3114 7511-Transport truck drivers
2224 8611-Harvesting labourers
1947 9617-Labourers in food, beverage and associated products processing
1414 2174-Computer programmers and interactive media developers
1216 8252-Agricultural service contractors, farm supervisors and specialized livestock workers
1185 2173-Software engineers and designers
1159 7271-Carpenters
1031 2171-Information systems analysts and consultants
970 6211-Retail sales supervisors
922 7237-Welders and related machine operators
779 7611-Construction trades helpers and labourers
606 6331-Butchers, meat cutters and fishmongers - retail and wholesale
596 1241-Administrative assistants
563 7284-Plasterers, drywall installers and finishers and lathers
545 5241-Graphic designers and illustrators