Table: mission_boston_data
Columns: serial
airborne_unit
troop_carrier_group
of_c_47s
uk_base
drop_zone
drop_zone_time

Question: What is the average drop zone time in the N drop zone for the 1st Pathfinder Prov.?
SQL: SELECT AVG("drop_zone_time") FROM mission_boston_data WHERE "drop_zone" = 'n' AND "troop_carrier_group" = '1st pathfinder prov.'

Question: Which UK Base has an airborne unit of Pathfinders?
SQL: SELECT "uk_base" FROM mission_boston_data WHERE "airborne_unit" = 'pathfinders'