CREATE TABLE table_name_46 (listed VARCHAR, construction_completed VARCHAR)

What construction completed on 08/10/2007?
SELECT listed FROM table_name_46 WHERE construction_completed = "08/10/2007"
SELECT "listed" FROM "table_name_46" WHERE "08/10/2007" = "construction_completed"