Table: mills_list
Columns: ref
name
built
location
construction

Question: What is the name of the mill located on Anawan Street with a reference number larger than 8?
SQL: SELECT "name" FROM mills_list WHERE "ref" > 8 AND "location" = 'anawan street'

Question: What is the name of the mill constructed of red brick in 1910 with a reference number lower than 55?
SQL: SELECT "name" FROM mills_list WHERE "ref" < 55 AND "built" = 1910 AND "construction" = 'red brick'

Question: What is the location of the Durfee Mill No. 1, built before 1872 ?
SQL: SELECT "location" FROM mills_list WHERE "built" < 1872 AND "name" = 'durfee mill no. 1'

Question: What is the location of the mill with a reference number of 44?
SQL: SELECT "location" FROM mills_list WHERE "ref" = 44