CREATE TABLE person (name CLOB, age NUMBER, city CLOB, gender CLOB, job CLOB)
CREATE TABLE personfriend (name CLOB, friend CLOB, year NUMBER)

list the name, job title of all people ordered by their names.
SELECT name, job FROM person ORDER BY name
SELECT "name", "job" FROM "person" ORDER BY "name"