CREATE TABLE bridge (architect_id NUMBER, id NUMBER, name CLOB, location CLOB, length_meters NUMBER, length_feet NUMBER)
CREATE TABLE architect (id CLOB, name CLOB, nationality CLOB, gender CLOB)
CREATE TABLE mill (architect_id NUMBER, id NUMBER, location CLOB, name CLOB, type CLOB, built_year NUMBER, notes CLOB)

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"