When the Year is smaller than 2004, and Mike Joy is the Lap-by-lap, what are the Ratings?
CREATE TABLE table_name_86 (ratings VARCHAR, year VARCHAR, lap_by_lap VARCHAR)
SELECT ratings FROM table_name_86 WHERE year < 2004 AND lap_by_lap = "mike joy"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_86 (ratings VARCHAR, year VARCHAR, lap_by_lap VARCHAR) Question: When the Year is smaller than 2004, and Mike Joy is the Lap-by-lap, what are the Ratings? [/INST] SELECT ratings FROM table_name_86 WHERE year < 2004 AND lap_by_lap = "mike joy" </s>