Table: fighter_pilot_stats
Columns: date
id_code_of_his_zero_fighter
flight_hours
count
sub_total

Question: Which Zero Fighter has a count of 10?
SQL: SELECT "id_code_of_his_zero_fighter" FROM fighter_pilot_stats WHERE "count" = '10'

Question: On which day were the subtotal hours 9:30?
SQL: SELECT "date" FROM fighter_pilot_stats WHERE "sub_total" = '9:30'

Question: What is the count for the Zero Fighter with hours of 2:00?
SQL: SELECT "count" FROM fighter_pilot_stats WHERE "flight_hours" = '2:00'