Table: samantha_episodes
Columns: order
episode
air_date
u_s_timeslot_est
18_49
viewers

Question: What is the sum of numbers listed in 18-49 for the episode that aired on June 25, 2009 with an order larger than 29?
SQL: SELECT SUM("18_49") FROM samantha_episodes WHERE "air_date" = 'june 25, 2009' AND "order" > 29

Question: What is the total 18-49 for the episode that aired on July 2, 2009 with more than 3.5 viewers?
SQL: SELECT COUNT("18_49") FROM samantha_episodes WHERE "air_date" = 'july 2, 2009' AND "viewers" > 3.5

Question: What was the timeslot in the US for the episode, "the farm"?
SQL: SELECT "u_s_timeslot_est" FROM samantha_episodes WHERE "episode" = '"the farm"'

Question: What is the average 18-49 for the episode that had an order number higher than 35 and less than 3.5 viewers?
SQL: SELECT AVG("18_49") FROM samantha_episodes WHERE "viewers" < 3.5 AND "order" > 35

Question: What is the episode name that aired on July 23, 2009 with more than 3.31 viewers?
SQL: SELECT "episode" FROM samantha_episodes WHERE "air_date" = 'july 23, 2009' AND "viewers" > 3.31