Table: t_49ers_2008_season
Columns: week
date
time_pt
opponent
result
record
game_site

Question: How many weeks have September 14, 2008 as the date?
SQL: SELECT SUM("week") FROM t_49ers_2008_season WHERE "date" = 'september 14, 2008'

Question: What opponent has a week less than 16, with September 7, 2008 as the date?
SQL: SELECT "opponent" FROM t_49ers_2008_season WHERE "week" < 16 AND "date" = 'september 7, 2008'

Question: What record has candlestick park as the game site, and october 12, 2008 as the date?
SQL: SELECT "record" FROM t_49ers_2008_season WHERE "game_site" = 'candlestick park' AND "date" = 'october 12, 2008'

Question: What date has new england patriots as the opponent?
SQL: SELECT "date" FROM t_49ers_2008_season WHERE "opponent" = 'new england patriots'

Question: What date has 10 for the week?
SQL: SELECT "date" FROM t_49ers_2008_season WHERE "week" = 10

Question: What game site has w 10-3 as the result?
SQL: SELECT "game_site" FROM t_49ers_2008_season WHERE "result" = 'w 10-3'