Database: architecture
Question: What are the ids and names of the architects who built at least 3 bridges ?
SQL:
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(*)  >=  3