Task: Text to Code
Input (English): SQL: SELECT name , gender , gender FROM architect GROUP BY id HAVING Count ( * ) > = 1
Feedback: Replace first gender with id , Remove last part , Make sure architect build two bridges or one mill .
Output (English): 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