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

How old is each gender, on average. Plot them as bar chart.
SELECT gender, AVG(age) FROM Person GROUP BY gender
SELECT "gender", AVG("age") FROM "Person" GROUP BY "gender"