SELECT DISTINCT T1.type FROM mill AS T1 JOIN architect AS t2 ON T1.architect_id  =  T2.id WHERE T2.nationality  =  'American' OR T2.nationality  =  'Canadian'
What are the distinct types of mills that are built by American or Canadian architects?
SELECT DISTINCT T1.type FROM mill AS T1 JOIN architect AS t2 ON T1.architect_id = T2.id WHERE T2.nationality = 'American ' OR T2.nationality = 'Canadian '
select distinct t1 . type from mill as t1 join architect as t2 on t1 . architect_id = t2 . id where t2 . nationality = value or t2 . nationality = value
What are the distinct types of mills that are built by American or Canadian architects ?