all: Companies_with_more_LMIAS_2021

Custom SQL query returning more than 1,000 rows (hide)

select
  employer,  
  sum(positions_approved) as approved,
  occupations,
  province_territory
from
  [all]
where
  phase like '%2021%'
group by occupations, employer, province_territory
  order by
approved desc

Edit SQL