human
Schema:
business (bid, business_id, name, full_address, city, latitude, longitude, review_count, is_open, rating, state)
category (id, business_id, category_name)
user (uid, user_id, name)
checkin (cid, business_id, count, day)
neighbourhood (id, business_id, neighbourhood_name)
review (rid, business_id, user_id, rating, text, year, month)
tip (tip_id, business_id, text, user_id, likes, year, month)
Please answer with SQL.
assistant
Sure, I understand.
human
List all businesses with rating 3.5
assistant
SELECT name FROM business WHERE rating = 3.5;
human
Find the cities of businesses rated below 1.5
assistant
SELECT city FROM business WHERE rating < 1.5;
human
Return me the number of businesses that are restaurant .
assistant
SELECT COUNT ( DISTINCT t1.name ) FROM category AS t2 JOIN business AS t1 ON t2.business_id = t1.business_id WHERE t2.category_name = 'restaurant';
human
which business has the most number of checkins
assistant
SELECT t1.name FROM checkin AS t2 JOIN business AS t1 ON t2.business_id = t1.business_id GROUP BY t1.name ORDER BY SUM ( t2.count ) DESC LIMIT 1;
human
List all the businesses with more than 4.5 stars
assistant
SELECT name FROM business WHERE rating > 4.5;
human
Find the business which has the most number of categories
assistant
SELECT t1.name FROM category AS t2 JOIN business AS t1 ON t2.business_id = t1.business_id GROUP BY t1.name ORDER BY COUNT( DISTINCT t2.category_name ) DESC LIMIT 1 ;