where is the best restaurant in the bay area for american food ?
CREATE TABLE geographic (
    city_name varchar,
    county varchar,
    region varchar
)

CREATE TABLE restaurant (
    id int,
    name varchar,
    food_type varchar,
    city_name varchar,
    rating "decimal
)

CREATE TABLE location (
    restaurant_id int,
    house_number int,
    street_name varchar,
    city_name 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')
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: where is the best restaurant in the bay area for american food ? ### Input: CREATE TABLE geographic (
    city_name varchar,
    county varchar,
    region varchar
)

CREATE TABLE restaurant (
    id int,
    name varchar,
    food_type varchar,
    city_name varchar,
    rating "decimal
)

CREATE TABLE location (
    restaurant_id int,
    house_number int,
    street_name varchar,
    city_name varchar
) ### Response: 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')