question: What is the name for Charleston County with a CERCLIS ID of scd980711279?
answer: SELECT name FROM table_name_44 WHERE county = "charleston" AND cerclis_id = "scd980711279"
context: CREATE TABLE table_name_44 (name VARCHAR, county VARCHAR, cerclis_id VARCHAR)