CREATE TABLE PENALTIES (PAYMENTNO INTEGER NOT NULL, PLAYERNO INTEGER NOT NULL, PAYMENT_DATE DATE NOT NULL, AMOUNT DECIMAL(7,2) NOT NULL, PRIMARY KEY (PAYMENTNO) ); CREATE TABLE MATCHES (MATCHNO INTEGER NOT NULL, TEAMNO INTEGER NOT NULL, PLAYERNO INTEGER NOT NULL, WON SMALLINT NOT NULL, LOST SMALLINT NOT NULL, PRIMARY KEY (MATCHNO) ); INSERT INTO PENALTIES VALUES (1, 6, '1980-12-08',100); INSERT INTO PENALTIES VALUES (2, 44, '1981-05-05', 75); INSERT INTO PENALTIES VALUES (3, 27, '1983-09-10',100); INSERT INTO PENALTIES VALUES (4,104, '1984-12-08', 50); INSERT INTO PENALTIES VALUES (5, 44, '1980-12-08', 25); INSERT INTO PENALTIES VALUES (6, 8, '1980-12-08', 25); INSERT INTO PENALTIES VALUES (7, 44, '1982-12-30', 30); INSERT INTO PENALTIES VALUES (8, 27, '1984-11-12', 75); INSERT INTO MATCHES VALUES ( 1, 1, 6, 3, 1); INSERT INTO MATCHES VALUES ( 2, 1, 6, 2, 3); INSERT INTO MATCHES VALUES ( 3, 1, 6, 3, 0); INSERT INTO MATCHES VALUES ( 4, 1, 44, 3, 2); INSERT INTO MATCHES VALUES ( 5, 1, 83, 0, 3); INSERT INTO MATCHES VALUES ( 6, 1, 2, 1, 3); INSERT INTO MATCHES VALUES ( 7, 1, 57, 3, 0); INSERT INTO MATCHES VALUES ( 8, 1, 8, 0, 3);   INSERT INTO MATCHES VALUES ( 9, 2, 27, 3, 2); INSERT INTO MATCHES VALUES (10, 2, 104, 3, 2); INSERT INTO MATCHES VALUES (11, 2, 112, 2, 3); INSERT INTO MATCHES VALUES (12, 2, 112, 1, 3); INSERT INTO MATCHES VALUES (13, 2, 8, 0, 3); In the PENALTIES table, change the column name AMOUNT to PENALTY_AMOUNT. Add a new column called Date of type date to the MATCHES table. In the MATCHES table, change the column name MATCHNO to MATCH. MATCH is a keyword but this can be done.

CREATE TABLE PENALTIES

(PAYMENTNO INTEGER NOT NULL,

PLAYERNO INTEGER NOT NULL,

PAYMENT_DATE DATE NOT NULL,

AMOUNT DECIMAL(7,2) NOT NULL,

PRIMARY KEY (PAYMENTNO) );

CREATE TABLE MATCHES

(MATCHNO INTEGER NOT NULL,

TEAMNO INTEGER NOT NULL,

PLAYERNO INTEGER NOT NULL,

WON SMALLINT NOT NULL,

LOST SMALLINT NOT NULL,

PRIMARY KEY (MATCHNO) );

INSERT INTO PENALTIES VALUES (1, 6, '1980-12-08',100);

INSERT INTO PENALTIES VALUES (2, 44, '1981-05-05', 75);

INSERT INTO PENALTIES VALUES (3, 27, '1983-09-10',100);

INSERT INTO PENALTIES VALUES (4,104, '1984-12-08', 50);

INSERT INTO PENALTIES VALUES (5, 44, '1980-12-08', 25);

INSERT INTO PENALTIES VALUES (6, 8, '1980-12-08', 25);

INSERT INTO PENALTIES VALUES (7, 44, '1982-12-30', 30);

INSERT INTO PENALTIES VALUES (8, 27, '1984-11-12', 75);

INSERT INTO MATCHES VALUES ( 1, 1, 6, 3, 1);

INSERT INTO MATCHES VALUES ( 2, 1, 6, 2, 3);

INSERT INTO MATCHES VALUES ( 3, 1, 6, 3, 0);

INSERT INTO MATCHES VALUES ( 4, 1, 44, 3, 2);

INSERT INTO MATCHES VALUES ( 5, 1, 83, 0, 3);

INSERT INTO MATCHES VALUES ( 6, 1, 2, 1, 3);

INSERT INTO MATCHES VALUES ( 7, 1, 57, 3, 0);

INSERT INTO MATCHES VALUES ( 8, 1, 8, 0, 3);

INSERT INTO MATCHES VALUES ( 9, 2, 27, 3, 2);

INSERT INTO MATCHES VALUES (10, 2, 104, 3, 2);

INSERT INTO MATCHES VALUES (11, 2, 112, 2, 3);

INSERT INTO MATCHES VALUES (12, 2, 112, 1, 3);

INSERT INTO MATCHES VALUES (13, 2, 8, 0, 3);

1. In the PENALTIES table, change the column name AMOUNT to PENALTY_AMOUNT.
2. Add a new column called Date of type date to the MATCHES table.
3. In the MATCHES table, change the column name MATCHNO to MATCH. MATCH is a keyword but this can be done.