daily pastebin goal
31%
SHARE
TWEET

Untitled

a guest Oct 16th, 2018 76 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
  1. 1. Get all restaurants
  2. SELECT * FROM restaurants;
  3.  
  4. 2. Get Italian Restaurants
  5. SELECT * FROM restaurants
  6.   WHERE cuisine='Italian';
  7.  
  8. 3. Get 10 Italian restaurants, subset of fields\q
  9. SELECT id,name FROM restaurants
  10.   WHERE cuisine='Italian'
  11.   LIMIT 10;
  12.  
  13. 4. count of Thai restaurants
  14. SELECT count(*) from restaurants
  15.   WHERE cuisine = 'Thai';
  16.  
  17. 5. count of restaurants
  18. SELECT count(*) from restaurants;
  19.  
  20. 6. Count of Thai restaurants in zip code
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top