all: More_demanded_occupations_by_providence_2021

Custom SQL query returning 106 rows (hide)

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

Edit SQL