SELECT COUNT(*) FROM geographic, restaurant WHERE geographic.county = 'yolo county' AND restaurant.city_name = geographic.city_name AND restaurant.food_type = 'italian'
how many italian restaurants are in the yolo county ?
CREATE TABLE location (
    restaurant_id int,
    house_number int,
    street_name varchar,
    city_name varchar
)

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
)