Table schema:
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?
SQL: SELECT song FROM table_name_1 WHERE weeks_on_top = 2 AND artist = "david essex"