For the week of August 6, who is the finalist?
CREATE TABLE table_name_26 (finalist VARCHAR, week VARCHAR)
SELECT finalist FROM table_name_26 WHERE week = "august 6"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_26 (finalist VARCHAR, week VARCHAR) Question: For the week of August 6, who is the finalist? [/INST] SELECT finalist FROM table_name_26 WHERE week = "august 6" </s>