text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  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?
  ### Answer:
  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