WHAT IS THE POSITION WITH A LOST OF 6, FOR CAERNARFON TOWN?
CREATE TABLE table_name_29 (position INTEGER, lost VARCHAR, team VARCHAR)
SELECT SUM(position) FROM table_name_29 WHERE lost = 6 AND team = "caernarfon town"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_29 (position INTEGER, lost VARCHAR, team VARCHAR) Question: WHAT IS THE POSITION WITH A LOST OF 6, FOR CAERNARFON TOWN? [/INST] SELECT SUM(position) FROM table_name_29 WHERE lost = 6 AND team = "caernarfon town" </s>