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

Can you compute the number of people with different job titles? Plot them as a bar graph.
SELECT job, COUNT(job) FROM Person GROUP BY job ORDER BY name
SELECT "job", COUNT("job") FROM "Person" GROUP BY "job" ORDER BY "name" NULLS FIRST