What is the name of the mill constructed of red brick in 1910 with a reference number lower than 55?
CREATE TABLE table_name_7 (name VARCHAR, construction VARCHAR, ref_number VARCHAR, built VARCHAR)
SELECT name FROM table_name_7 WHERE ref_number < 55 AND built = 1910 AND construction = "red brick"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_7 (name VARCHAR, construction VARCHAR, ref_number VARCHAR, built VARCHAR) Question: What is the name of the mill constructed of red brick in 1910 with a reference number lower than 55? [/INST] SELECT name FROM table_name_7 WHERE ref_number < 55 AND built = 1910 AND construction = "red brick" </s>