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

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(*) = 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