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_1 (song VARCHAR, weeks_on_top VARCHAR, artist VARCHAR)
  ### Question:
  Which song by David Essex spent 2 weeks on top of the charts?
  ### Answer:
  SELECT song FROM table_name_1 WHERE weeks_on_top = 2 AND artist = "david essex"