Search companies by noc

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

select
  employer,  
  sum(positions_approved) as approved,
  occupations,
  province_territory
from
  [all]
where
  lower(occupations) like lower('%' || :noc || '%')
group by occupations, employer, province_territory
  order by
approved desc, province_territory

Query parameters

noc

Edit SQL