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

Please give me a bar chart to show the names and job titles of every person ordered alphabetically by name?
SELECT job, COUNT(job) FROM Person GROUP BY job ORDER BY name
SELECT "job", COUNT("job") FROM "Person" GROUP BY "job" ORDER BY "name"