Table: jets_2000_season
Columns: week
date
opponent
result
game_site
attendance

Question: What was the attendance for each game held at Foxboro Stadium?
SQL: SELECT "attendance" FROM jets_2000_season WHERE "game_site" = 'foxboro stadium'

Question: When was the game against the Indianapolis Colts?
SQL: SELECT "date" FROM jets_2000_season WHERE "opponent" = 'indianapolis colts'

Question: How many weeks total did the New York Jets face the Pittsburgh Steelers?
SQL: SELECT COUNT("week") FROM jets_2000_season WHERE "opponent" = 'pittsburgh steelers'