Table: superfund_sites_sc
Columns: cerclis_id
name
county
proposed
listed

Question: What name has a listed of 03/31/1989 in spartanburg county?
SQL: SELECT "name" FROM superfund_sites_sc WHERE "listed" = '03/31/1989' AND "county" = 'spartanburg'

Question: What date was proposed when the listed date was 12/16/1994 in the County of beaufort?
SQL: SELECT "proposed" FROM superfund_sites_sc WHERE "listed" = '12/16/1994' AND "county" = 'beaufort'

Question: What name was listed 02/21/1990, and a CERCLIS ID of scd980844005?
SQL: SELECT "name" FROM superfund_sites_sc WHERE "listed" = '02/21/1990' AND "cerclis_id" = 'scd980844005'

Question: What county has a CERCLIS ID of scd037405362?
SQL: SELECT "county" FROM superfund_sites_sc WHERE "cerclis_id" = 'scd037405362'

Question: What is the name for Charleston County with a CERCLIS ID of scd980711279?
SQL: SELECT "name" FROM superfund_sites_sc WHERE "county" = 'charleston' AND "cerclis_id" = 'scd980711279'

Question: What is the name for the listed date of 11/21/1989?
SQL: SELECT "name" FROM superfund_sites_sc WHERE "listed" = '11/21/1989'