WHERE THE WEEK NUMBER WAS TOP 8, WHAT WAS THE THEME?
CREATE TABLE table_15778392_1 (theme VARCHAR, week__number VARCHAR)
SELECT theme FROM table_15778392_1 WHERE week__number = "Top 8"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_15778392_1 (theme VARCHAR, week__number VARCHAR) Question: WHERE THE WEEK NUMBER WAS TOP 8, WHAT WAS THE THEME? [/INST] SELECT theme FROM table_15778392_1 WHERE week__number = "Top 8" </s>