Table: idaho_superfund_sites
Columns: cerclis_id
name
county
proposed
listed
construction_completed
partially_deleted
deleted

Question: When was construction completed that was listed on 09/21/1984 and a Deleted of 11/04/1999?
SQL: SELECT "construction_completed" FROM idaho_superfund_sites WHERE "listed" = '09/21/1984' AND "deleted" = '11/04/1999'

Question: What is the partially deleted result for a completed construction of m– in St. Maries Creosote?
SQL: SELECT "partially_deleted" FROM idaho_superfund_sites WHERE "construction_completed" = '–' AND "name" = 'st. maries creosote'

Question: What is the partially deleted result for Bunker Hill Mining & Metallurgical?
SQL: SELECT "partially_deleted" FROM idaho_superfund_sites WHERE "name" = 'bunker hill mining & metallurgical'

Question: What is the partially deleted result for a deleted of m– in Valley?
SQL: SELECT "partially_deleted" FROM idaho_superfund_sites WHERE "deleted" = '–' AND "county" = 'valley'