Table: tv_schedule_080708
Columns: 8_00
8_30
9_00
9_30
10_00

Question: What is on at 9:00 when at 10:00 it is local programming and at 8:30 it is decision house (reruns)?
SQL: SELECT "9_00" FROM tv_schedule_080708 WHERE "10_00" = 'local programming' AND "8_30" = 'decision house (reruns)'

Question: What is on at 8:00 when at 8:30 it is the bachelorette?
SQL: SELECT "8_00" FROM tv_schedule_080708 WHERE "8_30" = 'the bachelorette'

Question: what is on a 8:30 when at 9:00 it is one tree hill (reruns)?
SQL: SELECT "8_30" FROM tv_schedule_080708 WHERE "9_00" = 'one tree hill (reruns)'

Question: What is at 8:30 when at 9:30 it is rules of engagement (reruns)?
SQL: SELECT "8_30" FROM tv_schedule_080708 WHERE "9_30" = 'rules of engagement (reruns)'