How many different weeks are there in order number 4 that were judge's choice?
CREATE TABLE table_27614707_1 (week__number VARCHAR, theme VARCHAR, order__number VARCHAR)
SELECT COUNT(week__number) FROM table_27614707_1 WHERE theme = "Judge's Choice" AND order__number = "4"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_27614707_1 (week__number VARCHAR, theme VARCHAR, order__number VARCHAR) Question: How many different weeks are there in order number 4 that were judge's choice? [/INST] SELECT COUNT(week__number) FROM table_27614707_1 WHERE theme = "Judge's Choice" AND order__number = "4" </s>