all: More_demanded_occupations_by_providence_2020

Custom SQL query returning 58 rows (hide)

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

approvedoccupationsprovince_territory
591 7511-Transport truck drivers Alberta
445 8431-General farm workers Alberta
425 6311-Food service supervisors Alberta
360 6322-Cooks Alberta
217 8432-Nursery and greenhouse workers Alberta
208 6211-Retail sales supervisors Alberta
132 8252-Agricultural service contractors, farm supervisors and specialized livestock workers Alberta
113 7282-Concrete finishers Alberta
4746 8431-General farm workers British Columbia
829 8432-Nursery and greenhouse workers British Columbia
798 7511-Transport truck drivers British Columbia
681 6322-Cooks British Columbia
421 6311-Food service supervisors British Columbia
358 8611-Harvesting labourers British Columbia
179 8252-Agricultural service contractors, farm supervisors and specialized livestock workers British Columbia
150 0631-Restaurant and food service managers British Columbia
146 7271-Carpenters British Columbia
122 9617-Labourers in food, beverage and associated products processing British Columbia
117 1241-Administrative assistants British Columbia
104 4214-Early childhood educators and assistants British Columbia
358 8431-General farm workers Manitoba
148 7511-Transport truck drivers Manitoba
1111 9463-Fish and seafood plant workers New Brunswick
155 8431-General farm workers New Brunswick
683 8431-General farm workers Nova Scotia
236 9463-Fish and seafood plant workers Nova Scotia
5600 8431-General farm workers Ontario
2408 8432-Nursery and greenhouse workers Ontario
412 9617-Labourers in food, beverage and associated products processing Ontario
398 7511-Transport truck drivers Ontario
324 6322-Cooks Ontario
311 2173-Software engineers and designers Ontario
285 8611-Harvesting labourers Ontario
268 6311-Food service supervisors Ontario
168 2174-Computer programmers and interactive media developers Ontario
152 8252-Agricultural service contractors, farm supervisors and specialized livestock workers Ontario
525 9463-Fish and seafood plant workers Prince Edward Island
208 8431-General farm workers Prince Edward Island
8415 8431-General farm workers Quebec
887 8432-Nursery and greenhouse workers Quebec
857 9617-Labourers in food, beverage and associated products processing Quebec
612 8612-Landscaping and grounds maintenance labourers Quebec
402 7237-Welders and related machine operators Quebec
242 7511-Transport truck drivers Quebec
227 2174-Computer programmers and interactive media developers Quebec
213 2171-Information systems analysts and consultants Quebec
186 6322-Cooks Quebec
172 9618-Labourers in fish and seafood processing Quebec
166 5241-Graphic designers and illustrators Quebec
160 7321-Automotive service technicians, truck and bus mechanics and mechanical repairers Quebec
153 3413-Nurse aides, orderlies and patient service associates Quebec
136 6311-Food service supervisors Quebec
134 7231-Machinists and machining and tooling inspectors Quebec
134 7611-Construction trades helpers and labourers Quebec
119 3012-Registered nurses and registered psychiatric nurses Quebec
118 7441-Residential and commercial installers and servicers Quebec
110 9461-Process control and machine operators, food, beverage and associated products processing Quebec
231 8431-General farm workers Saskatchewan
Powered by Datasette · Query took 35.055ms