Table: longest_soap_actors
Columns: actor
character
soap_opera
years
duration

Question: what is the soap opera when the duration is 18 years and the character is miley byrne?
SQL: SELECT "soap_opera" FROM longest_soap_actors WHERE "duration" = '18 years' AND "character" = 'miley byrne'

Question: what is the years when the duration is 13 years and the character is renee phelan?
SQL: SELECT "years" FROM longest_soap_actors WHERE "duration" = '13 years' AND "character" = 'renee phelan'

Question: what is the years when the soap opera is glenroe and the actor is mick lally?
SQL: SELECT "years" FROM longest_soap_actors WHERE "soap_opera" = 'glenroe' AND "actor" = 'mick lally'

Question: who is the actor when the character is dinny byrne?
SQL: SELECT "actor" FROM longest_soap_actors WHERE "character" = 'dinny byrne'

Question: what is the soap opera when the actor is dave duffy?
SQL: SELECT "soap_opera" FROM longest_soap_actors WHERE "actor" = 'dave duffy'