ร้านอาหารอเมริกันที่ดีที่สุดในบริเวณอ่าวอยู่ที่ไหน ?ไม่จำเป็นต้องใช้โต๊ะทั้งหมด
where is the best restaurant in the bay area for american food ?It is not neccessary to use all the tables.
 geographic:  city_name [ varchar]  county [ varchar]  region [ varchar] 
SELECT location.house_number, restaurant.name FROM geographic, location, restaurant WHERE geographic.region = 'bay area' AND restaurant.city_name = geographic.city_name AND restaurant.food_type = 'american' AND restaurant.id = location.restaurant_id AND restaurant.rating = (SELECT MAX(RESTAURANTalias1.rating) FROM geographic AS GEOGRAPHICalias1, restaurant AS RESTAURANTalias1 WHERE GEOGRAPHICalias1.region = 'bay area' AND RESTAURANTalias1.city_name = GEOGRAPHICalias1.city_name AND RESTAURANTalias1.food_type = 'american')