Table: east_carolina_pirates_football
Columns: date
opponent
site
result
attendance

Question: Who was the opponent when the attendance was 80,079?
SQL: SELECT "opponent" FROM east_carolina_pirates_football WHERE "attendance" = '80,079'

Question: Who was the opponent when the attendance was 31,002?
SQL: SELECT "opponent" FROM east_carolina_pirates_football WHERE "attendance" = '31,002'

Question: Who was the opponent when they played at the legion field • birmingham, al site?
SQL: SELECT "opponent" FROM east_carolina_pirates_football WHERE "site" = 'legion field • birmingham, al'

Question: On which site was the game against Louisville played?
SQL: SELECT "site" FROM east_carolina_pirates_football WHERE "opponent" = 'louisville'

Question: What was the total attendance on September 12?
SQL: SELECT "attendance" FROM east_carolina_pirates_football WHERE "date" = 'september 12'