CREATE TABLE employee (fname TEXT, minit TEXT, lname TEXT, ssn DECIMAL, bdate TEXT, address TEXT, sex TEXT, salary DECIMAL, super_ssn DECIMAL, dno DECIMAL)
CREATE TABLE dependent (essn DECIMAL, dependent_name TEXT, sex TEXT, bdate TEXT, relationship TEXT)
CREATE TABLE department (dname TEXT, dnumber DECIMAL, mgr_ssn DECIMAL, mgr_start_date TEXT)
CREATE TABLE works_on (essn DECIMAL, pno DECIMAL, hours DECIMAL)
CREATE TABLE project (pname TEXT, pnumber DECIMAL, plocation TEXT, dnum DECIMAL)
CREATE TABLE dept_locations (dnumber DECIMAL, dlocation TEXT)

how many female dependents are there?
SELECT COUNT(*) FROM dependent WHERE sex = 'F'
SELECT COUNT(*) FROM "dependent" WHERE "sex" = 'F'