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_78 (goals INTEGER, year VARCHAR, national_team VARCHAR, apps VARCHAR)
  ### Question:
  How many Goals have a National team of england, and Apps smaller than 6, and a Year of 2012?
  ### Answer:
  SELECT SUM(goals) FROM table_name_78 WHERE national_team = "england" AND apps < 6 AND year = "2012"