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

What show was on at 8:00 when american idol was on at 9:00?
SELECT "8:00" FROM table_41946 WHERE "9:00" = 'american idol'
SELECT "8:00" FROM "table_41946" WHERE "9:00" = 'american idol'