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
what is the best french restaurant 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.food_type = 'french' AND t1.rating = ( SELECT MAX ( t1.rating ) FROM restaurant AS t1 JOIN LOCATION AS t2 ON t1.id = t2.restaurant_id WHERE t2.city_name = 'san francisco' AND t1.food_type = 'french' );
human
how many places for french food are there in palo alto ?
assistant
SELECT COUNT ( * ) FROM restaurant AS t1 JOIN LOCATION AS t2 ON t1.id = t2.restaurant_id WHERE t2.city_name = 'palo alto' AND t1.food_type = 'french';
human
give me some restaurants good for french food ?
assistant
SELECT t2.house_number , t1.name FROM restaurant AS t1 JOIN LOCATION AS t2 ON t1.id = t2.restaurant_id WHERE t1.food_type = 'french' AND t1.rating > 2.5;
human
where can i eat french 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 = 'french';
human
where can i eat french food in the bay area ?
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 = 'french';
human
where can i eat some good french food in the yosemite and mono lake area ?
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 = "yosemite AND mono lake area" AND t1.food_type = "french" AND t1.rating > 2.5 ;