◀ Back to Playground Home

Find all the trips in Manhattan

select *
from nyctaxis 
WHERE IN_SUBQUERY(
  DOLocationID,
  'SELECT ID_SET(locationID)
   FROM taxiZones
   WHERE borough = ''Manhattan''
  '
) = 1