question: What soap opera has a rank larger than 1, and a Character named Emily Bishop?
answer: SELECT soap_opera FROM table_name_81 WHERE rank > 1 AND character = "emily bishop"
context: CREATE TABLE table_name_81 (soap_opera VARCHAR, rank VARCHAR, character VARCHAR)