CREATE TABLE table_name_80 (launch_date VARCHAR2, cospar_id VARCHAR2)

When was the satellite that has a COSPAR ID of 1967-042a launched?
SELECT launch_date FROM table_name_80 WHERE cospar_id = "1967-042a"
SELECT "launch_date" FROM "table_name_80" WHERE "1967-042a" = "cospar_id"