What are the distinct names and nationalities of the architects who have ever built a mill?
create table mill (id varchar, PRIMARY KEY (id)); create table architect (name varchar, nationality varchar, id varchar, PRIMARY KEY (name))
select distinct t1.name, t1.nationality from architect as t1 join mill as t2 on t1.id = t2.architect_id