What soap opera has a rank larger than 1, and a Character named Emily Bishop?
CREATE TABLE table_name_81 (soap_opera VARCHAR, rank VARCHAR, character VARCHAR)
SELECT soap_opera FROM table_name_81 WHERE rank > 1 AND character = "emily bishop"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_81 (soap_opera VARCHAR, rank VARCHAR, character VARCHAR) Question: What soap opera has a rank larger than 1, and a Character named Emily Bishop? [/INST] SELECT soap_opera FROM table_name_81 WHERE rank > 1 AND character = "emily bishop" </s>