user: ### NOW ANSWER:
Question: Which song by David Essex spent 2 weeks on top of the charts?
Columns: ['Volume:Issue', 'Issue Date(s)', 'Weeks on Top', 'Song', 'Artist']
Types: ['text', 'text', 'real', 'text', 'text']
Sample row: ['20:20-21', '29 December 1973 – 5 January 1974', 2.0, '" The Most Beautiful Girl in the World "', 'Charlie Rich']
SQL:

assistant: SELECT "Song" FROM "Table" WHERE "Weeks on Top" = 2.0 AND "Artist" = 'David Essex';