Table: christine_langan_awards
Columns: year
award
category
title
result

Question: What Category has a Year that's smaller than 2006, has Result of Nominated, and a Title of Cold Feet?
SQL: SELECT "category" FROM christine_langan_awards WHERE "year" < 2006 AND "result" = 'nominated' AND "title" = 'cold feet'

Question: What is recorded as the lowest Year that has the Title of Cold Feet?
SQL: SELECT MIN("year") FROM christine_langan_awards WHERE "title" = 'cold feet'

Question: What Category has a Result of Nominated, Year of 2006, and the Title of Pierrepoint?
SQL: SELECT "category" FROM christine_langan_awards WHERE "result" = 'nominated' AND "year" = 2006 AND "title" = 'pierrepoint'

Question: What Title is listed for the Year of 1999?
SQL: SELECT "title" FROM christine_langan_awards WHERE "year" = 1999

Question: What is the total number of Year for the Title of The Queen, has an Award of British Academy Film Award, and has a Result of Won?
SQL: SELECT COUNT("year") FROM christine_langan_awards WHERE "title" = 'the queen' AND "award" = 'british academy film award' AND "result" = 'won'