Database: architecture
Question: What are the distinct name of the mills built by the architects who have also built a bridge longer than 80 meters?
SQL:
SELECT DISTINCT T1.name FROM mill AS T1 JOIN architect AS t2 ON T1.architect_id  =  T2.id JOIN bridge AS T3 ON T3.architect_id  =  T2.id WHERE T3.length_meters  >  80