Table: ncaaf_rankings_2008
Columns: week_2_sept_7
week_3_sept_14
week_4_sept_21
week_5_sept_28
week_6_oct_5
week_7_oct_12
week_10_nov_2
week_12_nov_16
week_14_nov_30
week_15_dec_7
week_16_final_jan_9

Question: What was the week 5 opponent for the year with a week 10 opponent of Maryland (6-2)?
SQL: SELECT "week_5_sept_28" FROM ncaaf_rankings_2008 WHERE "week_10_nov_2" = 'maryland (6-2)'

Question: What was the week 14 opponent for the year with a week 10 opponent of Michigan State (8-2)?
SQL: SELECT "week_14_nov_30" FROM ncaaf_rankings_2008 WHERE "week_10_nov_2" = 'michigan state (8-2)'

Question: What is the week 4 opponent for the year with a week 10 opponent of Michigan State (8-2)?
SQL: SELECT "week_4_sept_21" FROM ncaaf_rankings_2008 WHERE "week_10_nov_2" = 'michigan state (8-2)'

Question: What is the week 12 opponent for the year that had a week 3 opponent of South Florida (3-0)?
SQL: SELECT "week_12_nov_16" FROM ncaaf_rankings_2008 WHERE "week_3_sept_14" = 'south florida (3-0)'

Question: What was the week 7 opponent for the year that had a week 12 opponent of Oregon State (7-3)?
SQL: SELECT "week_7_oct_12" FROM ncaaf_rankings_2008 WHERE "week_12_nov_16" = 'oregon state (7-3)'

Question: What was the week 3 opponent for the year that had a week 7 opponent of Georgia (5-1)?
SQL: SELECT "week_3_sept_14" FROM ncaaf_rankings_2008 WHERE "week_7_oct_12" = 'georgia (5-1)'