CREATE TABLE architect (name VARCHAR, nationality VARCHAR, id VARCHAR, gender VARCHAR)

List the name, nationality and id of all male architects ordered by their names lexicographically.
SELECT name, nationality, id FROM architect WHERE gender = 'male' ORDER BY name
SELECT "name", "nationality", "id" FROM "architect" WHERE "gender" = 'male' ORDER BY "name" NULLS FIRST