Suppose we have the following table defined in our database: CREATE TABLE SOCCER TEAM TEAM NO TEAM NAME TEAM CITY YEAR-OF-ORIGIN int(8) PRIMARY varchar(32), varchar (64), int(4) KEY Given this table, suppose we wanted to create a second table called SOCCER PLAYER with three fields: SOCCER PLAYER NO, an integer field which is the primary key: SOCCER PLAYER NAME, a variable-length character field (max 40); and SOCCER TEAM_NO, a foreign key to the primary key of SOCCER TEAM. Construct the SQL statement required to create this table