Skip to content

Instantly share code, notes, and snippets.

@deatheragetr

deatheragetr/gist:5721324

Created June 6, 2013 12:59
Show Gist options
  • Save deatheragetr/5721324 to your computer and use it in GitHub Desktop.
Save deatheragetr/5721324 to your computer and use it in GitHub Desktop.
Download ZIP
Answers to AirBnB questions :)
Raw
gistfile1.txt
SELECT * FROM listings WHERE city = 'SFO';
SELECT * FROM listings WHERE city = 'SFO' AND host_id = 1;
SELECT * FROM listings WHERE room_type = 'shared';
SELECT * FROM listings WHERE room_type = 'private';
SELECT * FROM listings WHERE host_id = 3;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment