What is the average drop zone time in the N drop zone for the 1st Pathfinder Prov.?
CREATE TABLE table_name_22 (drop_zone INTEGER, troop_carrier_group VARCHAR)
SELECT AVG(drop_zone) AS Time FROM table_name_22 WHERE drop_zone = "n" AND troop_carrier_group = "1st pathfinder prov."
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_22 (drop_zone INTEGER, troop_carrier_group VARCHAR) Question: What is the average drop zone time in the N drop zone for the 1st Pathfinder Prov.? [/INST] SELECT AVG(drop_zone) AS Time FROM table_name_22 WHERE drop_zone = "n" AND troop_carrier_group = "1st pathfinder prov." </s>