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

Count the job title of all people using a pie chart.
SELECT job, COUNT(job) FROM Person GROUP BY job
SELECT "job", COUNT("job") FROM "Person" GROUP BY "job"