Table: soap_actors
Columns: rank
actor
character
soap_opera
years
duration

Question: What soap opera has a rank larger than 1, and a Character named Emily Bishop?
SQL: SELECT "soap_opera" FROM soap_actors WHERE "rank" > 1 AND "character" = 'emily bishop'

Question: What is the highest Rank 1960—?
SQL: SELECT MAX("rank") FROM soap_actors WHERE "years" = '1960—'

Question: What is the name of the actor with a duration of 61 years?
SQL: SELECT "actor" FROM soap_actors WHERE "duration" = '61 years'

Question: What are the years for Eileen Derbyshire with a duration of 52 years?
SQL: SELECT "years" FROM soap_actors WHERE "duration" = '52 years' AND "actor" = 'eileen derbyshire'

Question: What soap opera was on 1960–1965, 1965–1983, 1984–2010?
SQL: SELECT "soap_opera" FROM soap_actors WHERE "years" = '1960–1965, 1965–1983, 1984–2010'