What is the No. 6 of the person with a No. 10 of Joshua and a No. 8 of Andrew?
CREATE TABLE table_name_56 (no_6 VARCHAR, no_10 VARCHAR, no_8 VARCHAR)
SELECT no_6 FROM table_name_56 WHERE no_10 = "joshua" AND no_8 = "andrew"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_56 (no_6 VARCHAR, no_10 VARCHAR, no_8 VARCHAR) Question: What is the No. 6 of the person with a No. 10 of Joshua and a No. 8 of Andrew? [/INST] SELECT no_6 FROM table_name_56 WHERE no_10 = "joshua" AND no_8 = "andrew" </s>