Table: eurovision_uk
Columns: year_s
final_television_commentator
radio_commentator
spokesperson
semi_final_television_commentator
semi_final_second_television_commentator

Question: In how many years was Tom Fleming the final television commentator? 
SQL: SELECT COUNT("year_s") FROM eurovision_uk WHERE "final_television_commentator" = 'Tom Fleming'

Question: What was the latest year that Colin Berry was the spokesperson? 
SQL: SELECT MAX("year_s") FROM eurovision_uk WHERE "spokesperson" = 'Colin Berry'

Question: Who was the semi-final television commentator when the spokesperson was Colin Berry and the final television commentator was Pete Murray?
SQL: SELECT "semi_final_television_commentator" FROM eurovision_uk WHERE "spokesperson" = 'Colin Berry' AND "final_television_commentator" = 'Pete Murray'

Question: Who was the radio commentator when the final television commentator was John Dunn? 
SQL: SELECT "radio_commentator" FROM eurovision_uk WHERE "final_television_commentator" = 'John Dunn'

Question: What is the latest year that the final television commentator was David Jacobs? 
SQL: SELECT MAX("year_s") FROM eurovision_uk WHERE "final_television_commentator" = 'David Jacobs'