Project

General

Profile

Query_500_reviews_ONLY_on_restaurants_21042015.txt

Davary Mehdy, 21.04.2015 14:15

 
1
-- 500 reviews on restaurants with the Business review Count
2

    
3
SELECT r.text
4
FROM yelp.review r JOIN yelp.business b
5
ON (r.business_id = b.business_id)
6
WHERE categories LIKE '%Restaurants%' AND r.useful > 3 AND r.stars > 3 AND b.review_count > 5 AND r.cool > 2
7
limit 500;