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

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