CREATE TABLE Person (gender VARCHAR2, age NUMBER)

Find the number of people who is under 40 for each gender.
SELECT COUNT(*), gender FROM Person WHERE age < 40 GROUP BY gender
SELECT COUNT(*), "gender" FROM "Person" WHERE "age" < 40 GROUP BY "gender"