all: LMIA_computation_smallplaces

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

select * from [all] 
  where ( 
  lower(address) not like '%toronto%' and 
  lower(address) not like '%qu%bec%' and 
  lower(address) not like '%montr%al%' and 
  lower(address) not like '%vancouver%' 
  ) and 
  ( 
    lower(occupations) like '%comp%' or 
    lower(occupations) like '%soft%' 
  )

Edit SQL