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

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"