Project

General

Profile

Query_500_reviews_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.business_id, name, r.text, r.review_id, r.date, r.stars, r.funny, r.useful, r.cool, b.review_count
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;