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

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"