CREATE TABLE Person (name VARCHAR2, age NUMBER, city CLOB, gender CLOB, job CLOB)
CREATE TABLE PersonFriend (name VARCHAR2, friend VARCHAR2, year NUMBER)

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"