List the name, nationality and id of all male architects ordered by their names lexicographically.
CREATE TABLE architect (name VARCHAR, nationality VARCHAR, id VARCHAR, gender VARCHAR)
SELECT name, nationality, id FROM architect WHERE gender = 'male' ORDER BY name
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE architect (name VARCHAR, nationality VARCHAR, id VARCHAR, gender VARCHAR) Question: List the name, nationality and id of all male architects ordered by their names lexicographically. [/INST] SELECT name, nationality, id FROM architect WHERE gender = 'male' ORDER BY name </s>