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

How old is the average person for each job. Show a pie chart.
SELECT job, AVG(age) FROM Person GROUP BY job
SELECT "job", AVG("age") FROM "Person" GROUP BY "job"