What are the distinct name of the mills built by the architects who have also built a bridge longer than 80 meters?
create table architect (id varchar, PRIMARY KEY (id)); create table mill (name varchar, architect_id varchar, PRIMARY KEY (name)); create table bridge (architect_id varchar, length_meters integer, PRIMARY KEY (architect_id))
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