Table: dragons_den_appearances
Columns: seat
series_1
series_3
series_4
series_5

Question: What is the series 3 with gavin duffy in series 5?
SQL: SELECT "series_3" FROM dragons_den_appearances WHERE "series_5" = 'gavin duffy'

Question: What is the series 4 with sarah newman in series 1?
SQL: SELECT "series_4" FROM dragons_den_appearances WHERE "series_1" = 'sarah newman'

Question: What is the series 3 with more than 4 seats?
SQL: SELECT "series_3" FROM dragons_den_appearances WHERE "seat" > 4

Question: What is the total number of seats with gavin duffy in series 4?
SQL: SELECT COUNT("seat") FROM dragons_den_appearances WHERE "series_4" = 'gavin duffy'