Can you please tell me the names and the ids of the architects who have built two bridges?
select t1.id, t1.name from architect as t1 join bridge as t2 on t1.id = t2.architect_id group by t1.id having count ( * ) = 2
Great. Would you please list the ids, names and genders of architects have built one mill?
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