CREATE TABLE PersonFriend (name VARCHAR2, friend VARCHAR2, year NUMBER)
CREATE TABLE Person (name VARCHAR2, age NUMBER, city CLOB, gender CLOB, job CLOB)

Draw a bar chart for how many people are under 40 for each gender?
SELECT gender, COUNT(*) FROM Person WHERE age < 40 GROUP BY gender
SELECT "gender", COUNT(*) FROM "Person" WHERE "age" < 40 GROUP BY "gender"