Who was No. 8 when No. 1 Michael and No. 4 Logan?
CREATE TABLE table_name_48 (no_8 VARCHAR, no_1 VARCHAR, no_4 VARCHAR)
SELECT no_8 FROM table_name_48 WHERE no_1 = "michael" AND no_4 = "logan"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_48 (no_8 VARCHAR, no_1 VARCHAR, no_4 VARCHAR) Question: Who was No. 8 when No. 1 Michael and No. 4 Logan? [/INST] SELECT no_8 FROM table_name_48 WHERE no_1 = "michael" AND no_4 = "logan" </s>