Skip to content

Instantly share code, notes, and snippets.

@aveek22

aveek22/vw_mumbai_houses_airport_5km_west_facing.sql

Created January 9, 2021 22:58
Show Gist options
  • Save aveek22/83ad86e58f638df48513ff15cbc149a8 to your computer and use it in GitHub Desktop.
Save aveek22/83ad86e58f638df48513ff15cbc149a8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
vw_mumbai_houses_airport_5km_west_facing.sql
CREATE OR REPLACE VIEW vw_mumbai_houses_airport_5km_west_facing
AS
SELECT * FROM vw_mumbai_houses_airport_5km
WHERE 1=1
AND "desc" ~ '^.(W|w)est (F|f)acing.$'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment