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"
context: CREATE TABLE table_name_1 (song VARCHAR, weeks_on_top VARCHAR, artist VARCHAR)