We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Advanced Join
  4. 15 Days of Learning SQL
  5. Discussions

15 Days of Learning SQL

  • biskvitoj
     + 4 comments

    Here's the correct data:

    CREATE TABLE submissions (submission_date date, submission_id integer, hacker_id integer, score integer);
INSERT INTO "submissions" VALUES('2016-03-01',8494,20703,0);
INSERT INTO "submissions" VALUES('2016-03-01',22403,53473,15);
INSERT INTO "submissions" VALUES('2016-03-01',23965,79722,60);
INSERT INTO "submissions" VALUES('2016-03-01',30173,36396,70);
INSERT INTO "submissions" VALUES('2016-03-02',34928,20703,0);
INSERT INTO "submissions" VALUES('2016-03-02',38740,15758,60);
INSERT INTO "submissions" VALUES('2016-03-02',42769,79722,60);
INSERT INTO "submissions" VALUES('2016-03-02',44364,79722,60);
INSERT INTO "submissions" VALUES('2016-03-03',45440,20703,0);
INSERT INTO "submissions" VALUES('2016-03-03',49050,36396,70);
INSERT INTO "submissions" VALUES('2016-03-03',50273,79722,5);
INSERT INTO "submissions" VALUES('2016-03-04',50344,20703,0);
INSERT INTO "submissions" VALUES('2016-03-04',51360,44065,90);
INSERT INTO "submissions" VALUES('2016-03-04',54404,53473,65);
INSERT INTO "submissions" VALUES('2016-03-04',61533,79722,45);
INSERT INTO "submissions" VALUES('2016-03-05',72852,20703,0);
INSERT INTO "submissions" VALUES('2016-03-05',74546,38289,0);
INSERT INTO "submissions" VALUES('2016-03-05',76487,62529,0);
INSERT INTO "submissions" VALUES('2016-03-05',82439,36396,10);
INSERT INTO "submissions" VALUES('2016-03-05',9006,36396,40);
INSERT INTO "submissions" VALUES('2016-03-06',90404,20703,0);
CREATE TABLE hackers (hacker_id integer, name string);
INSERT INTO "hackers" VALUES(15758,'Rose');
INSERT INTO "hackers" VALUES(20703,'Angela');
INSERT INTO "hackers" VALUES(36396,'Frank');
INSERT INTO "hackers" VALUES(38289,'Patrick');
INSERT INTO "hackers" VALUES(44065,'Lisa');
INSERT INTO "hackers" VALUES(53473,'Kimberly');
INSERT INTO "hackers" VALUES(62529,'Bonnie');
INSERT INTO "hackers" VALUES(79722,'Michael');