What is the SQL statement to create tables in oracles for the statements below?

$1.$TEAM $1$: the name of the home team. A $30-$character field is $$

used to record this information.

$2.$ TEAM $2$: the name of the visiting team.

$3.$ SITE: a $20-$character alphanumeric field that is used to record

the stadium at which the game was played.

$4.$ ATTENDANCE: the attendance at the game. A $6-$digit numeric

field is used to record attendance.

$5.$ SCORE: two numbers that indicate the number of points

scored by each team in the game. A $3-$digit numeric field is

used to store this information.

$78$ Case $6$: The NCAA Data Base

Figure $6-9$

Display Used to Enter

Game Statistics.

November $24,198$x

Game Statistics

Team $1$: University of Pittsburgh

Team $2$: Penn State University

Site: Beaver Stadium, University Park

Attendance: $85000$

Score Team $1$: $42$

Score Team $2$: $35$

Injuries Team $1$: $3$

Injuries Team $2$: $2$

$($Note: User entries are underscored.$)$

$6.$ INJURIES: two numbers that indicate the number of injuries

incurred by each team in the game. Three$-$digit numeric fields

are used to store this information.

An application program that brings up the display shown in

Figure $6-9$ is used to store the above information at the conclusion

of each game.