Table: claire_cooper_soap_awards
Columns: year
result
award
category
film_or_series
character

Question: What film won best actress at the 2007 Inside Soap Awards?
SQL: SELECT "film_or_series" FROM claire_cooper_soap_awards WHERE "award" = 'inside soap awards' AND "category" = 'best actress' AND "year" = 2007

Question: What character won the best dramatic performance award?
SQL: SELECT "character" FROM claire_cooper_soap_awards WHERE "category" = 'best dramatic performance'

Question: In what category was character Jacqui Mcqueen nominated before 2011?
SQL: SELECT "category" FROM claire_cooper_soap_awards WHERE "character" = 'jacqui mcqueen' AND "year" < 2011