Find the number of female students (with F sex) living in Smith Hall
CREATE TABLE student (
    stuid VARCHAR,
    sex VARCHAR
)

CREATE TABLE lives_in (
    stuid VARCHAR,
    dormid VARCHAR
)

CREATE TABLE dorm (
    dormid VARCHAR,
    dorm_name VARCHAR
)
SELECT COUNT(*) FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid = T2.stuid JOIN dorm AS T3 ON T3.dormid = T2.dormid WHERE T3.dorm_name = 'Smith Hall' AND T1.sex = 'F'
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: Find the number of female students (with F sex) living in Smith Hall ### Input: CREATE TABLE student (
    stuid VARCHAR,
    sex VARCHAR
)

CREATE TABLE lives_in (
    stuid VARCHAR,
    dormid VARCHAR
)

CREATE TABLE dorm (
    dormid VARCHAR,
    dorm_name VARCHAR
) ### Response: SELECT COUNT(*) FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid = T2.stuid JOIN dorm AS T3 ON T3.dormid = T2.dormid WHERE T3.dorm_name = 'Smith Hall' AND T1.sex = 'F'