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
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 the best restaurant in the bay area for american food ?
assistant
SELECT t3.house_number , t1.name FROM restaurant AS t1 JOIN geographic AS t2 ON t1.city_name = t2.city_name JOIN LOCATION AS t3 ON t1.id = t3.restaurant_id WHERE t2.region = 'bay area' AND t1.food_type = 'american' AND t1.rating = ( SELECT MAX ( t1.rating ) FROM restaurant AS t1 JOIN geographic AS t2 ON t1.city_name = t2.city_name WHERE t2.region = 'bay area' AND t1.food_type = 'american' );
human
where can we find a restaurant in alameda ?
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 = 'alameda';
human
give me a good restaurant in alameda ?
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 = 'alameda' AND t1.rating > 2.5;
human
where are some restaurants good for arabic food in mountain view ?
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 = 'mountain view' AND t1.food_type = 'arabic' AND t1.rating > 2.5;
human
where is a restaurant on buchanan in san francisco that serves good arabic food ?
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 t2.street_name = "buchanan" AND t1.food_type = "arabic" AND t1.rating > 2.5 ;