Which Song has a Year smaller than 1979, and a US Hot 100 of 8?
CREATE TABLE table_name_1 (song VARCHAR, year VARCHAR, us_hot_100 VARCHAR)
SELECT song FROM table_name_1 WHERE year < 1979 AND us_hot_100 = "8"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_1 (song VARCHAR, year VARCHAR, us_hot_100 VARCHAR) Question: Which Song has a Year smaller than 1979, and a US Hot 100 of 8? [/INST] SELECT song FROM table_name_1 WHERE year < 1979 AND us_hot_100 = "8" </s>