Schema: CREATE TABLE table_name_4 (sunk_by_u_boat VARCHAR, sunk_by_mines VARCHAR, german_submarines_lost VARCHAR, sunk_by_aircraft VARCHAR)
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 table_name_4 WHERE german_submarines_lost < 2 AND sunk_by_aircraft = 56328 AND sunk_by_mines > 8269