CREATE TABLE personfriend (name TEXT, friend TEXT, year DECIMAL)
CREATE TABLE person (name TEXT, age DECIMAL, city TEXT, gender TEXT, job TEXT)

What are the names and job titles of every person ordered alphabetically by name?
SELECT name, job FROM person ORDER BY name
SELECT "name", "job" FROM "person" ORDER BY "name" NULLS FIRST