How many times has the student Linda Smith visited Subway?
CREATE TABLE type_of_restaurant (
    resid number,
    restypeid number
)

CREATE TABLE restaurant (
    resid number,
    resname text,
    address text,
    rating number
)

CREATE TABLE restaurant_type (
    restypeid number,
    restypename text,
    restypedescription text
)

CREATE TABLE visits_restaurant (
    stuid number,
    resid number,
    time time,
    spent number
)

CREATE TABLE student (
    stuid number,
    lname text,
    fname text,
    age number,
    sex text,
    major number,
    advisor number,
    city_code text
)
SELECT COUNT(*) FROM student JOIN visits_restaurant ON student.stuid = visits_restaurant.stuid JOIN restaurant ON visits_restaurant.resid = restaurant.resid WHERE student.fname = "Linda" AND student.lname = "Smith" AND restaurant.resname = "Subway"
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: How many times has the student Linda Smith visited Subway? ### Input: CREATE TABLE type_of_restaurant (
    resid number,
    restypeid number
)

CREATE TABLE restaurant (
    resid number,
    resname text,
    address text,
    rating number
)

CREATE TABLE restaurant_type (
    restypeid number,
    restypename text,
    restypedescription text
)

CREATE TABLE visits_restaurant (
    stuid number,
    resid number,
    time time,
    spent number
)

CREATE TABLE student (
    stuid number,
    lname text,
    fname text,
    age number,
    sex text,
    major number,
    advisor number,
    city_code text
) ### Response: SELECT COUNT(*) FROM student JOIN visits_restaurant ON student.stuid = visits_restaurant.stuid JOIN restaurant ON visits_restaurant.resid = restaurant.resid WHERE student.fname = "Linda" AND student.lname = "Smith" AND restaurant.resname = "Subway"