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

Compute the total the number of job across job as a pie chart.
SELECT job, COUNT(job) FROM Person GROUP BY job
SELECT "job", COUNT("job") FROM "Person" GROUP BY "job"