What race was a round smaller than 8,  on 6 july?
CREATE TABLE table_name_45 (race VARCHAR, round VARCHAR, date VARCHAR)
SELECT race FROM table_name_45 WHERE round < 8 AND date = "6 july"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_45 (race VARCHAR, round VARCHAR, date VARCHAR) Question: What race was a round smaller than 8,  on 6 july? [/INST] SELECT race FROM table_name_45 WHERE round < 8 AND date = "6 july" </s>