Table: battle_atlantic_losses
Columns: month_year
sunk_by_u_boat
sunk_by_aircraft
sunk_by_warship_or_raider
sunk_by_mines
german_submarines_lost

Question: What is the total number of sunk by U-boats with less than 2 German submarines lost, 56328 sunk by aircrafts, and more than 8269 sunk by mines?
SQL: SELECT COUNT("sunk_by_u_boat") FROM battle_atlantic_losses WHERE "german_submarines_lost" < 2 AND "sunk_by_aircraft" = 56328 AND "sunk_by_mines" > 8269

Question: What is the total number sunk by warship or raider with 20 German submarines lost and more than 21616 sunk by aircraft?
SQL: SELECT COUNT("sunk_by_warship_or_raider") FROM battle_atlantic_losses WHERE "german_submarines_lost" = 20 AND "sunk_by_aircraft" > 21616

Question: What is the total number of German submarines lost with more than 120958 sunk by mines?
SQL: SELECT COUNT("german_submarines_lost") FROM battle_atlantic_losses WHERE "sunk_by_mines" > 120958

Question: What is the month and year less than 5 German submarines were lost, less than 6893 were sunk by warship or raider, less than 133746 were sunk by aircraft, and more than 111263 were sunk by U-boat?
SQL: SELECT "month_year" FROM battle_atlantic_losses WHERE "german_submarines_lost" < 5 AND "sunk_by_warship_or_raider" < 6893 AND "sunk_by_aircraft" < 133746 AND "sunk_by_u_boat" > 111263

Question: What is the month and year less than 106005 were sunk by aircraft and 61857 were sunk by warship or raider?
SQL: SELECT "month_year" FROM battle_atlantic_losses WHERE "sunk_by_aircraft" < 106005 AND "sunk_by_warship_or_raider" = 61857