Table: cadet_competition_results
Columns: region
wing
inspection
standard
indoor
outdoor
written
panel_quiz
mile_run
points
overall

Question: What are the minimum indoor results that have a 5 for inspection? 
SQL: SELECT MIN("indoor") FROM cadet_competition_results WHERE "inspection" = 5

Question: What was the maximum number in written when the standard was 2? 
SQL: SELECT MAX("written") FROM cadet_competition_results WHERE "standard" = 2

Question: How many point categories are there for the 3 mile run? 
SQL: SELECT COUNT("points") FROM cadet_competition_results WHERE "mile_run" = 3

Question: What is the indoor number for the NJ wing/ 
SQL: SELECT "indoor" FROM cadet_competition_results WHERE "wing" = 'NJ'

Question: What is the indoor number for the NER region? 
SQL: SELECT COUNT("indoor") FROM cadet_competition_results WHERE "region" = 'NER'