CREATE TABLE table_179174_2 (spacecraft VARCHAR, launch_complex VARCHAR)

What spacecraft was launched from the LC34 launch complex?
SELECT spacecraft FROM table_179174_2 WHERE launch_complex = "LC34"
SELECT "spacecraft" FROM "table_179174_2" WHERE "LC34" = "launch_complex"