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_87 (tonnage INTEGER, date VARCHAR, name_of_ship VARCHAR)
  ### Question:
  What was the average tonnage for Beatus, raided on 18 October 1940?
  ### Answer:
  SELECT AVG(tonnage) FROM table_name_87 WHERE date = "18 october 1940" AND name_of_ship = "beatus"