human
Schema:
geographic (CITY_NAME, COUNTY, REGION)
restaurant (ID, NAME, FOOD_TYPE, CITY_NAME, RATING)
location (RESTAURANT_ID, HOUSE_NUMBER, STREET_NAME, CITY_NAME)
Please answer with SQL.
assistant
Sure, I understand.
human
how many chinese restaurants are there in the bay area ?
assistant
SELECT COUNT ( * ) FROM restaurant AS t1 JOIN geographic AS t2 ON t1.city_name = t2.city_name WHERE t2.region = 'bay area' AND t1.food_type = 'chinese';
human
how many denny are there in the bay area ?
assistant
SELECT COUNT ( * ) FROM restaurant AS t1 JOIN geographic AS t2 ON t1.city_name = t2.city_name WHERE t2.region = 'bay area' AND t1.name = 'denny';
human
how many italian restaurants are in the yolo county ?
assistant
SELECT COUNT ( * ) FROM restaurant AS t1 JOIN geographic AS t2 ON t1.city_name = t2.city_name WHERE t2.county = 'yolo county' AND t1.food_type = 'italian';
human
where can i find a jamerican cuisine in san francisco ?
assistant
SELECT t2.house_number , t1.name FROM restaurant AS t1 JOIN LOCATION AS t2 ON t1.id = t2.restaurant_id WHERE t2.city_name = 'san francisco' AND t1.name = 'jamerican cuisine';
human
where is jamerican cuisine ?
assistant
SELECT t2.house_number , t1.name FROM restaurant AS t1 JOIN LOCATION AS t2 ON t1.id = t2.restaurant_id WHERE t1.name = 'jamerican cuisine';
human
how many jamerican cuisine are there in santa cruz county ?
assistant
SELECT COUNT( * ) FROM restaurant AS t1 JOIN geographic AS t2 ON t1.city_name = t2.city_name WHERE t2.county = "santa cruz county" AND t1.name = "jamerican cuisine" ;