Table: gavin_stacey_chars
Columns: actor_actress
character
first_appearance
last_appearance
duration
total

Question: Who was the actor/actress with a first appearance is 3 june 2007?
SQL: SELECT "actor_actress" FROM gavin_stacey_chars WHERE "first_appearance" = '3 June 2007'

Question: Who was the actor/actress with a last appearance of 1 january 2010 and total is 20 and character is vanessa 'nessa' jenkins?
SQL: SELECT "actor_actress" FROM gavin_stacey_chars WHERE "last_appearance" = '1 January 2010' AND "total" = 20 AND "character" = 'Vanessa ''Nessa'' Jenkins'

Question: What is the highest total number?
SQL: SELECT MAX("total") FROM gavin_stacey_chars

Question: How many  characters where actor/actress is larry lamb?
SQL: SELECT COUNT("character") FROM gavin_stacey_chars WHERE "actor_actress" = 'Larry Lamb'

Question: What was the last appearance of actor/actress is pam ferris?
SQL: SELECT "last_appearance" FROM gavin_stacey_chars WHERE "actor_actress" = 'Pam Ferris'

Question: How many total are there when actor/actress is pam ferris?
SQL: SELECT "total" FROM gavin_stacey_chars WHERE "actor_actress" = 'Pam Ferris'