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

Pie chart. what is average age for different job title?
SELECT job, AVG(age) FROM Person GROUP BY job
SELECT "job", AVG("age") FROM "Person" GROUP BY "job"