CREATE TABLE table_41947 ("8:00" CLOB, "8:30" CLOB, "9:00" CLOB, "9:30" CLOB, "10:00" CLOB)

What was on at 8:30 when dancing with the stars: the results was on at 9:30?
SELECT "8:30" FROM table_41947 WHERE "9:30" = 'dancing with the stars: the results'
SELECT "8:30" FROM "table_41947" WHERE "9:30" = 'dancing with the stars: the results'