Create another table called "NextSeason" by copying the structure of the table "Season" and copying all the data from "Season"
into the new table.
Change the structure of "NextSeason" by adding the following field:
Innings (Integer)
Change the structure of "PastSeasons" by adding the following field:
Innings (Integer)
Delete the table "Season".
Rename the table "NextSeason" to "Season".
Create an index on the table "Teams", indexing on "TeamCode".
Create an index on the table "Players", indexing on "Team".
Based on the indexes, create a report or display of each team and the associated players on each team.