What are the ids, names and genders of the architects who built two bridges or one mill?
CREATE TABLE architect (
    id text,
    name text,
    nationality text,
    gender text
)

CREATE TABLE bridge (
    architect_id number,
    id number,
    name text,
    location text,
    length_meters number,
    length_feet number
)

CREATE TABLE mill (
    architect_id number,
    id number,
    location text,
    name text,
    type text,
    built_year number,
    notes text
)
SELECT T1.id, T1.name, T1.gender FROM architect AS T1 JOIN bridge AS T2 ON T1.id = T2.architect_id GROUP BY T1.id HAVING COUNT(*) = 2 UNION SELECT T1.id, T1.name, T1.gender FROM architect AS T1 JOIN mill AS T2 ON T1.id = T2.architect_id GROUP BY T1.id HAVING COUNT(*) = 1
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What are the ids, names and genders of the architects who built two bridges or one mill? ### Input: CREATE TABLE architect (
    id text,
    name text,
    nationality text,
    gender text
)

CREATE TABLE bridge (
    architect_id number,
    id number,
    name text,
    location text,
    length_meters number,
    length_feet number
)

CREATE TABLE mill (
    architect_id number,
    id number,
    location text,
    name text,
    type text,
    built_year number,
    notes text
) ### Response: SELECT T1.id, T1.name, T1.gender FROM architect AS T1 JOIN bridge AS T2 ON T1.id = T2.architect_id GROUP BY T1.id HAVING COUNT(*) = 2 UNION SELECT T1.id, T1.name, T1.gender FROM architect AS T1 JOIN mill AS T2 ON T1.id = T2.architect_id GROUP BY T1.id HAVING COUNT(*) = 1