Table: tv_serial_data
Columns: doctor
season
story_no
serial
number_of_episodes
total_footage_remaining_from_missing_episodes_mm_ss
missing_episodes_with_recovered_footage
country_territory
source
format
total_footage_mm_ss

Question: When a private individual is the source and 018 is the story number what is the total footage remaining from missing episodes (mm:ss)?
SQL: SELECT "total_footage_remaining_from_missing_episodes_mm_ss" FROM tv_serial_data WHERE "story_no" = '018' AND "source" = 'Private individual'

Question: When 01:18 is the  total footage remaining from missing episodes (mm:ss) and bbc is the source what is the country/territory? 
SQL: SELECT "country_territory" FROM tv_serial_data WHERE "source" = 'BBC' AND "total_footage_remaining_from_missing_episodes_mm_ss" = '01:18'

Question: When 00:21 is the total footage (mm:ss) what is the serial?
SQL: SELECT "serial" FROM tv_serial_data WHERE "total_footage_mm_ss" = '00:21'

Question: When episode 4 is the missing episode with recovered footage and the 032 is the story number what is the country/territory?
SQL: SELECT "country_territory" FROM tv_serial_data WHERE "story_no" = '032' AND "missing_episodes_with_recovered_footage" = 'Episode 4'

Question: When 00:02 is the total footage (mm:ss) what is the story number?
SQL: SELECT "story_no" FROM tv_serial_data WHERE "total_footage_mm_ss" = '00:02'