Last active
November 29, 2019 19:32
-
-
Save chidioguejiofor/49d6ca96edc3e1d9830f565f7df29cce to your computer and use it in GitHub Desktop.
Used in a blog post
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE results( | |
id SERIAL PRIMARY KEY, | |
student_id INT NOT NULL, | |
course VARCHAR NOT NULL, | |
score INT NOT NULL, | |
course_end_date DATE, | |
UNIQUE(student_id, course) | |
) | |
; | |
INSERT INTO | |
results(student_id,course,score,course_end_date) | |
VALUES | |
('9','Literature','79','2019-11-29'), | |
('10','Literature','63','2019-11-29'), | |
('11','Literature','68','2019-11-29'), | |
('12','Literature','61','2019-11-29'), | |
('13','Literature','60','2019-11-29'), | |
('14','Literature','78','2019-11-29'), | |
('15','Literature','60','2019-11-29'), | |
('16','Literature','61','2019-11-29'), | |
('17','Literature','68','2019-11-29'), | |
('18','Literature','79','2019-11-29'), | |
('1','Literature','0','2019-11-29'), | |
('2','Literature','73','2019-11-29'), | |
('4','Literature','77','2019-11-29'), | |
('5','Literature','62','2019-11-29'), | |
('6','Literature','61','2019-11-29'), | |
('7','Literature','77','2019-11-29'), | |
('1','Arts','49','2018-06-10'), | |
('1','History','72','2019-10-05'), | |
('1','Computer Science','74','2019-05-09'), | |
('1','Physics','71','2018-06-10'), | |
('1','Statistics','14','2019-10-05'), | |
('1','Mathematics','0','2019-05-09'), | |
('1','Economics','73','2019-02-20'), | |
('1','Physical Education','88','2019-02-20'), | |
('1','English Language','63','2018-06-10'), | |
('1','Chemistry','0','2019-10-05'), | |
('1','Biology','0','2019-02-20'), | |
('2','Commerce','76','2019-05-09'), | |
('2','Arts','76','2018-06-10'), | |
('2','History','71','2019-10-05'), | |
('2','Computer Science','77','2019-05-09'), | |
('2','Physics','73','2018-06-10'), | |
('2','Statistics','91','2019-10-05'), | |
('2','Mathematics','66','2019-05-09'), | |
('2','Economics','81','2019-02-20'), | |
('2','Physical Education','70','2019-02-20'), | |
('2','English Language','0','2018-06-10'), | |
('2','Chemistry','73','2019-10-05'), | |
('2','Biology','78','2019-02-20'), | |
('4','Commerce','66','2019-05-09'), | |
('4','Arts','70','2018-06-10'), | |
('4','History','78','2019-10-05'), | |
('4','Computer Science','52','2019-05-09'), | |
('4','Physics','80','2018-06-10'), | |
('4','Statistics','71','2019-10-05'), | |
('4','Mathematics','71','2019-05-09'), | |
('4','Economics','70','2019-02-20'), | |
('4','Physical Education','70','2019-02-20'), | |
('4','English Language','0','2018-06-10'), | |
('4','Chemistry','71','2019-10-05'), | |
('4','Biology','77','2019-02-20'), | |
('5','Commerce','75','2019-05-09'), | |
('5','Arts','72','2018-06-10'), | |
('5','History','68','2019-10-05'), | |
('5','Computer Science','79','2019-05-09'), | |
('5','Physics','79','2018-06-10'), | |
('5','Statistics','65','2019-10-05'), | |
('5','Mathematics','70','2019-05-09'), | |
('5','Economics','67','2019-02-20'), | |
('5','Physical Education','76','2019-02-20'), | |
('5','English Language','67','2018-06-10'), | |
('5','Chemistry','61','2019-10-05'), | |
('5','Biology','64','2019-02-20'), | |
('6','Commerce','66','2019-05-09'), | |
('6','Arts','69','2018-06-10'), | |
('6','History','66','2019-10-05'), | |
('6','Computer Science','60','2019-05-09'), | |
('6','Physics','76','2018-06-10'), | |
('6','Statistics','53','2019-10-05'), | |
('6','Mathematics','61','2019-05-09'), | |
('6','Economics','66','2019-02-20'), | |
('6','Physical Education','70','2019-02-20'), | |
('6','English Language','62','2018-06-10'), | |
('6','Chemistry','63','2019-10-05'), | |
('6','Biology','63','2019-02-20'), | |
('7','Commerce','73','2019-05-09'), | |
('7','Arts','75','2018-06-10'), | |
('7','History','80','2019-10-05'), | |
('7','Computer Science','92','2019-05-09'), | |
('7','Physics','66','2018-06-10'), | |
('7','Statistics','80','2019-10-05'), | |
('7','Mathematics','80','2019-05-09'), | |
('7','Economics','70','2019-02-20'), | |
('7','Physical Education','70','2019-02-20'), | |
('7','English Language','67','2018-06-10'), | |
('7','Chemistry','74','2019-10-05'), | |
('7','Biology','81','2019-02-20'), | |
('8','Commerce','68','2019-05-09'), | |
('8','Arts','71','2018-06-10'), | |
('8','History','67','2019-10-05'), | |
('8','Computer Science','70','2019-05-09'), | |
('8','Physics','69','2018-06-10'), | |
('8','Statistics','60','2019-10-05'), | |
('8','Mathematics','62','2019-05-09'), | |
('8','Economics','63','2019-02-20'), | |
('8','Physical Education','81','2019-02-20'), | |
('8','Chemistry','61','2019-10-05'), | |
('8','Biology','65','2019-02-20'), | |
('9','Commerce','82','2019-05-09'), | |
('9','Arts','80','2018-06-10'), | |
('9','History','84','2019-10-05'), | |
('9','Computer Science','93','2019-05-09'), | |
('9','Physics','85','2018-06-10'), | |
('9','Statistics','85','2019-10-05'), | |
('9','Mathematics','80','2019-05-09'), | |
('9','Economics','75','2019-02-20'), | |
('9','Physical Education','81','2019-02-20'), | |
('9','English Language','78','2018-06-10'), | |
('9','Chemistry','81','2019-10-05'), | |
('9','Biology','84','2019-02-20'), | |
('10','Commerce','69','2019-05-09'), | |
('10','Arts','79','2018-06-10'), | |
('10','History','76','2019-10-05'), | |
('10','Computer Science','76','2019-05-09'), | |
('10','Physics','78','2018-06-10'), | |
('10','Statistics','65','2019-10-05'), | |
('10','Mathematics','72','2019-05-09'), | |
('10','Economics','61','2019-02-20'), | |
('10','Physical Education','70','2019-02-20'), | |
('10','English Language','60','2018-06-10'), | |
('10','Biology','66','2019-02-20'), | |
('11','Commerce','61','2019-05-09'), | |
('11','Arts','70','2018-06-10'), | |
('11','History','74','2019-10-05'), | |
('11','Computer Science','51','2019-05-09'), | |
('11','Physics','76','2018-06-10'), | |
('11','Statistics','62','2019-10-05'), | |
('11','Mathematics','62','2019-05-09'), | |
('11','Economics','62','2019-02-20'), | |
('11','Physical Education','64','2019-02-20'), | |
('11','English Language','0','2018-06-10'), | |
('11','Biology','57','2019-02-20'), | |
('12','Commerce','44','2019-05-09'), | |
('12','Arts','45','2018-06-10'), | |
('12','History','62','2019-10-05'), | |
('12','Computer Science','40','2019-05-09'), | |
('12','Physics','60','2018-06-10'), | |
('12','Statistics','52','2019-10-05'), | |
('12','Mathematics','47','2019-05-09'), | |
('12','Economics','62','2019-02-20'), | |
('12','Physical Education','60','2019-02-20'), | |
('12','English Language','56','2018-06-10'), | |
('12','Biology','0','2019-02-20'), | |
('13','Commerce','63','2019-05-09'), | |
('13','Arts','77','2018-06-10'), | |
('13','History','75','2019-10-05'), | |
('13','Computer Science','71','2019-05-09'), | |
('13','Physics','76','2018-06-10'), | |
('13','Statistics','58','2019-10-05'), | |
('13','Mathematics','64','2019-05-09'), | |
('13','Economics','72','2019-02-20'), | |
('13','Physical Education','80','2019-02-20'), | |
('13','English Language','69','2018-06-10'), | |
('13','Chemistry','62','2019-10-05'), | |
('13','Biology','65','2019-02-20'), | |
('14','Commerce','80','2019-05-09'), | |
('14','Arts','80','2018-06-10'), | |
('14','History','76','2019-10-05'), | |
('14','Computer Science','84','2019-05-09'), | |
('14','Physics','89','2018-06-10'), | |
('14','Statistics','61','2019-10-05'), | |
('14','Mathematics','75','2019-05-09'), | |
('14','Economics','75','2019-02-20'), | |
('14','Physical Education','74','2019-02-20'), | |
('14','English Language','70','2018-06-10'), | |
('14','Chemistry','70','2019-10-05'), | |
('14','Biology','74','2019-02-20'), | |
('15','Commerce','60','2019-05-09'), | |
('15','Arts','71','2018-06-10'), | |
('15','History','72','2019-10-05'), | |
('15','Computer Science','65','2019-05-09'), | |
('15','Physics','72','2018-06-10'), | |
('15','Statistics','57','2019-10-05'), | |
('15','Mathematics','63','2019-05-09'), | |
('15','Economics','60','2019-02-20'), | |
('15','Physical Education','60','2019-02-20'), | |
('15','English Language','60','2018-06-10'), | |
('15','Biology','0','2019-02-20'), | |
('16','Commerce','70','2019-05-09'), | |
('16','Arts','67','2018-06-10'), | |
('16','History','73','2019-10-05'), | |
('16','Computer Science','80','2019-05-09'), | |
('16','Physics','73','2018-06-10'), | |
('16','Statistics','66','2019-10-05'), | |
('16','Mathematics','65','2019-05-09'), | |
('16','Economics','63','2019-02-20'), | |
('16','Physical Education','65','2019-02-20'), | |
('16','English Language','73','2018-06-10'), | |
('16','Chemistry','67','2019-10-05'), | |
('16','Biology','70','2019-02-20'), | |
('17','Commerce','66','2019-05-09'), | |
('17','Arts','70','2018-06-10'), | |
('17','History','73','2019-10-05'), | |
('17','Computer Science','87','2019-05-09'), | |
('17','Physics','79','2018-06-10'), | |
('17','Statistics','76','2019-10-05'), | |
('17','Mathematics','70','2019-05-09'), | |
('17','Economics','65','2019-02-20'), | |
('17','Physical Education','80','2019-02-20'), | |
('17','English Language','65','2018-06-10'), | |
('17','Chemistry','60','2019-10-05'), | |
('17','Biology','77','2019-02-20'), | |
('18','Commerce','65','2019-05-09'), | |
('18','Arts','76','2018-06-10'), | |
('18','History','0','2019-10-05'), | |
('18','Computer Science','85','2019-05-09'), | |
('18','Physics','74','2018-06-10'), | |
('18','Statistics','62','2019-10-05'), | |
('18','Mathematics','80','2019-05-09'), | |
('18','Economics','69','2019-02-20'), | |
('18','Physical Education','60','2019-02-20'), | |
('18','English Language','67','2018-06-10'), | |
('18','Chemistry','71','2019-10-05'), | |
('18','Biology','73','2019-02-20'), | |
('19','Commerce','70','2019-05-09'), | |
('19','Arts','71','2018-06-10'), | |
('19','History','75','2019-10-05'), | |
('19','Computer Science','66','2019-05-09'), | |
('19','Physics','71','2018-06-10'), | |
('19','Statistics','80','2019-10-05'), | |
('19','Mathematics','71','2019-05-09'), | |
('19','Economics','70','2019-02-20'), | |
('8','Literature','66','2019-11-29'), | |
('19','Physical Education','80','2019-02-20'), | |
('19','English Language','68','2018-06-10'), | |
('19','Chemistry','75','2019-10-05'), | |
('19','Biology','71','2019-02-20'), | |
('20','Commerce','63','2019-05-09'), | |
('20','Arts','50','2018-06-10'), | |
('20','History','0','2019-10-05'), | |
('20','Computer Science','60','2019-05-09'), | |
('20','Physics','67','2018-06-10'), | |
('20','Statistics','54','2019-10-05'), | |
('20','Mathematics','60','2019-05-09'), | |
('20','Economics','63','2019-02-20'), | |
('20','Physical Education','64','2019-02-20'), | |
('20','English Language','49','2018-06-10'), | |
('20','Chemistry','40','2019-10-05'), | |
('20','Biology','55','2019-02-20'), | |
('21','Commerce','62','2019-05-09'), | |
('21','Arts','47','2018-06-10'), | |
('21','History','60','2019-10-05'), | |
('21','Computer Science','35','2019-05-09'), | |
('21','Physics','64','2018-06-10'), | |
('21','Statistics','48','2019-10-05'), | |
('21','Mathematics','60','2019-05-09'), | |
('21','Economics','67','2019-02-20'), | |
('21','Physical Education','68','2019-02-20'), | |
('21','English Language','0','2018-06-10'), | |
('21','Chemistry','0','2019-10-05'), | |
('21','Biology','0','2019-02-20'), | |
('22','Commerce','55','2019-05-09'), | |
('22','Arts','70','2018-06-10'), | |
('22','History','68','2019-10-05'), | |
('22','Computer Science','63','2019-05-09'), | |
('22','Physics','75','2018-06-10'), | |
('22','Statistics','49','2019-10-05'), | |
('22','Mathematics','60','2019-05-09'), | |
('22','Economics','67','2019-02-20'), | |
('22','Physical Education','61','2019-02-20'), | |
('22','English Language','66','2018-06-10'), | |
('22','Chemistry','41','2019-10-05'), | |
('22','Biology','56','2019-02-20'), | |
('23','Commerce','65','2019-05-09'), | |
('23','Arts','67','2018-06-10'), | |
('23','History','72','2019-10-05'), | |
('23','Computer Science','72','2019-05-09'), | |
('23','Physics','79','2018-06-10'), | |
('23','Statistics','57','2019-10-05'), | |
('23','Mathematics','65','2019-05-09'), | |
('23','Economics','39','2019-02-20'), | |
('23','Physical Education','87','2019-02-20'), | |
('23','English Language','61','2018-06-10'), | |
('23','Chemistry','36','2019-10-05'), | |
('23','Biology','0','2019-02-20'), | |
('24','Commerce','83','2019-05-09'), | |
('24','Arts','83','2018-06-10'), | |
('24','History','85','2019-10-05'), | |
('24','Computer Science','97','2019-05-09'), | |
('24','Physics','91','2018-06-10'), | |
('24','Statistics','88','2019-10-05'), | |
('24','Mathematics','91','2019-05-09'), | |
('24','Economics','80','2019-02-20'), | |
('24','Physical Education','89','2019-02-20'), | |
('24','English Language','76','2018-06-10'), | |
('24','Chemistry','82','2019-10-05'), | |
('24','Biology','85','2019-02-20'), | |
('19','Literature','65','2019-11-29'), | |
('20','Literature','60','2019-11-29'), | |
('21','Literature','62','2019-11-29'), | |
('22','Literature','66','2019-11-29'), | |
('23','Literature','53','2019-11-29'), | |
('24','Literature','88','2019-11-29'), | |
('10','Chemistry','80','2019-10-05'), | |
('11','Chemistry','85','2019-10-05'), | |
('12','Chemistry','70','2019-10-05'), | |
('15','Chemistry','90','2019-10-05'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment