CREATE TABLE has_pet (stuid VARCHAR(255), petid VARCHAR(255)); CREATE TABLE pets (petid VARCHAR(255), pettype VARCHAR(255)); CREATE TABLE student (stuid VARCHAR(255), sex VARCHAR(255))
Find the number of dog pets that are raised by female students (with sex F).
    
SQL: SELECT COUNT(*) FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T2.petid = T3.petid WHERE T1.sex = 'F' AND T3.pettype = 'dog'