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

Count job title of all people ordered by their names using a bar chart.
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