What is the name for Charleston County with a CERCLIS ID of scd980711279?
CREATE TABLE table_name_44 (name VARCHAR, county VARCHAR, cerclis_id VARCHAR)
SELECT name FROM table_name_44 WHERE county = "charleston" AND cerclis_id = "scd980711279"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_44 (name VARCHAR, county VARCHAR, cerclis_id VARCHAR) Question: What is the name for Charleston County with a CERCLIS ID of scd980711279? [/INST] SELECT name FROM table_name_44 WHERE county = "charleston" AND cerclis_id = "scd980711279" </s>