Find all mills that were built before year 1850.
select * from mill where built_year < 1850
What are the ids of the architects who built a mill before year 1850?
select architect_id from mill where built_year < 1850
How many other architects are there?
select count(*) from architect where id not in ( select architect_id from mill where built_year < 1850 )