CREATE TABLE people (is_male VARCHAR2, age VARCHAR2)

How many female people are older than 30 in our record?
SELECT COUNT(*) FROM people WHERE is_male = 'F' AND age > 30
SELECT COUNT(*) FROM "people" WHERE "age" > 30 AND "is_male" = 'F'