CREATE TABLE table_12074 ("Show" CLOB, "Theme" CLOB, "Song" CLOB, "Original artist" CLOB, "Order" CLOB, "Result" CLOB)

For the week 1 show and order 2, what was the theme?
SELECT "Theme" FROM table_12074 WHERE "Show" = 'week 1' AND "Order" = '2'
SELECT "Theme" FROM "table_12074" WHERE "Order" = '2' AND "Show" = 'week 1'