XVat824v

1/* IMPORTANT CHANGE WITH YOUR OWN SCHEMA*/
2USE `classicmodels`; 
3
4/*Table structure for table `stats` */
5
6DROP TABLE IF EXISTS `SOCCER_STATS`;
7
8CREATE TABLE `SOCCER_STATS` (
9`ID` INT NOT NULL,
10`PLAYER` VARCHAR(45) NULL,
11`TEAM` VARCHAR(45) NULL,
12`GOALS` INT NULL,
13PRIMARY KEY (`ID`));
14
15/* CREATE RECORDS */
16
17INSERT INTO SOCCER_STATS  (ID, PLAYER, TEAM, GOALS) VALUES (1,'Mohamed Salah','Liverpool',16);
18INSERT INTO SOCCER_STATS  (ID, PLAYER, TEAM, GOALS) VALUES (2,'Roberto Firmino','Liverpool',9);
19INSERT INTO SOCCER_STATS  (ID, PLAYER, TEAM, GOALS) VALUES (3,'Sadio Mané','Liverpool',9);
20INSERT INTO SOCCER_STATS  (ID, PLAYER, TEAM, GOALS) VALUES (4,'Xherdan Shaqiri','Liverpool',6);
21INSERT INTO SOCCER_STATS  (ID, PLAYER, TEAM, GOALS) VALUES (5,'James Milner','Liverpool',3);
22INSERT INTO SOCCER_STATS  (ID, PLAYER, TEAM, GOALS) VALUES (6,'Daniel Sturridge','Liverpool',2);
23INSERT INTO SOCCER_STATS  (ID, PLAYER, TEAM, GOALS) VALUES (7,'Trent Alexander-Arnold','Liverpool',1);
24INSERT INTO SOCCER_STATS  (ID, PLAYER, TEAM, GOALS) VALUES (8,'Dejan Lovren','Liverpool',1);
25INSERT INTO SOCCER_STATS  (ID, PLAYER, TEAM, GOALS) VALUES (9,'Joel Matip','Liverpool',1);
26INSERT INTO SOCCER_STATS  (ID, PLAYER, TEAM, GOALS) VALUES (10,'Divock Origi','Liverpool',1);
27INSERT INTO SOCCER_STATS  (ID, PLAYER, TEAM, GOALS) VALUES (11,'Fabinho','Liverpool',1);
28INSERT INTO SOCCER_STATS  (ID, PLAYER, TEAM, GOALS) VALUES (12,'Virgil van Dijk','Liverpool',1);
29INSERT INTO SOCCER_STATS  (ID, PLAYER, TEAM, GOALS) VALUES (13,'Georginio Wijnaldum','Liverpool',1);
30
31
32/* TESTING THE IMPORT - THE NUMBER WILL BE 48 */
33SELECT SUM(GOALS) GOALS FROM SOCCER_STATS;