Schema: CREATE TABLE dependent (sex VARCHAR)
Question: how many female dependents are there?
SQL: SELECT COUNT(*) FROM dependent WHERE sex = 'F'