There are two tables

table 1

table 2

TE in the table 2 means the State of the team city

Prompt for a Game Date, then display the total number of minutes played for every team for this date. If the team did not play on that date, the team still needs to be displayed with a value of 0. The answer will have columns "Game Date", TeamName, and "Total Minutes Played" Prompt for a Game Date, then display the total number of minutes played for every team for this date. If the team did not play on that date, the team still needs to be displayed with a value of 0. The answer will have columns "Game Date", TeamName, and "Total Minutes Played