Which song by David Essex spent 2 weeks on top of the charts?
CREATE TABLE table_name_1 (song VARCHAR, weeks_on_top VARCHAR, artist VARCHAR)
SELECT song FROM table_name_1 WHERE weeks_on_top = 2 AND artist = "david essex"
<s>[INST] Write mssql query to answer the following question given the database schema. 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? [/INST] SELECT song FROM table_name_1 WHERE weeks_on_top = 2 AND artist = "david essex" </s>