Translate the following question to SQL: What are the ids, names and genders of the architects who built two bridges or one mill?

Schema: CREATE TABLE architect (
    id TEXT   PRIMARY KEY,
    name TEXT,
    nationality TEXT,
    gender TEXT,
    UNIQUE (id)
);

CREATE TABLE bridge (
    architect_id INT,
    id INT   PRIMARY KEY,
    name TEXT,
    location TEXT,
    length_meters REAL,
    length_feet REAL,
    UNIQUE (id),
    FOREIGN KEY (architect_id) REFERENCES architect(id)
);

CREATE TABLE mill (
    architect_id INT,
    id INT   PRIMARY KEY,
    location TEXT,
    name TEXT,
    type TEXT,
    built_year INT,
    notes TEXT,
    UNIQUE (id),
    FOREIGN KEY (architect_id) REFERENCES architect(id)
);
user
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
assistant