CREATE TABLE Person (name VARCHAR, age INT, city TEXT, gender TEXT, job TEXT)
CREATE TABLE PersonFriend (name VARCHAR, friend VARCHAR, year INT)

Draw a bar chart for how many people are under 40 for each gender?, and rank from low to high by the the total number .
SELECT gender, COUNT(*) FROM Person WHERE age < 40 GROUP BY gender ORDER BY COUNT(*)
SELECT "gender", COUNT(*) FROM "Person" WHERE "age" < 40 GROUP BY "gender" ORDER BY COUNT(*) NULLS FIRST