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

Question: what is at 10:00 when at 9:00 it is lost (#19, 4.6 rating) and at 8:30 it is lost (reruns)?
SQL: SELECT "10_00" FROM tv_schedule_2007_08 WHERE "9_00" = 'lost (#19, 4.6 rating)' AND "8_30" = 'lost (reruns)'

Question: What is at 9:00 when at 10:00 it is local programming and at 9:30 it is my thursday night movie?
SQL: SELECT "9_00" FROM tv_schedule_2007_08 WHERE "10_00" = 'local programming' AND "9_30" = 'my thursday night movie'

Question: what is at 9:30 when at 8:30 it is scrubs?
SQL: SELECT "9_30" FROM tv_schedule_2007_08 WHERE "8_30" = 'scrubs'

Question: what is at 10:00 when at 9:00 it is reaper?
SQL: SELECT "10_00" FROM tv_schedule_2007_08 WHERE "9_00" = 'reaper'

Question: what is at 10:00 when at 8:30 it is scrubs?
SQL: SELECT "10_00" FROM tv_schedule_2007_08 WHERE "8_30" = 'scrubs'

Question: what is at 8:00 when at 8:30 it is my thursday night movie?
SQL: SELECT "8_00" FROM tv_schedule_2007_08 WHERE "8_30" = 'my thursday night movie'