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
What are the ids, names and genders of the architects who built two bridges or one mill?
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
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 ( * ) = value 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 ( * ) = value
What are the ids , names and genders of the architects who built two bridges or one mill ?