CREATE TABLE public.roster (
    student_id SERIAL,
    first_name VARCHAR(50),
    last_name VARCHAR(50)
);
INSERT INTO public.roster (first_name,last_name) VALUES
('Hailey','Gray'),
('Jackie','Matthews'),
('Alvin','Murphy'),
('Lee','Bell'),
('Eva','Little'),
('Eugene','Gomez'),
('Douglas','Pierce'),
('Eli','Gomez'),
('Antonio','Gardner'),
('Joel','Adams'),
('Byron','Campbell'),
('Marlene','Holmes'),
('Priscilla','Perkins'),
('Jack','Pearson'),
('Harold','Bryant'),
('Frederick','Montgomery'),
('Luke','Young'),
('Holly','Howell'),
('Stephen','Garrett'),
('Austin','Ortiz'),
('Madison','Hayes'),
('Frederick','Henderson'),
('Frederick','Moore'),
('Monica','Scott'),
('Warren','Pena'),
('Julio','Carpenter'),
('Dianne','Carlson'),
('Jacob','Garrett'),
('Vincent','Rodriguez'),
('Gregory','Garza'),
('Katrina','Kuhn'),
('Jackie','Peck'),
('Hugh','Simmons'),
('Alice','Lee'),
('Randy','Richards'),
('Peyton','Fernandez'),
('Kevin','Ward'),
('Wanda','Johnston'),
('Ida','Wade'),
('Roberta','Powell'),
('Hilda','Kennedy'),
('Lena','Mendoza'),
('Andy','Jimenez'),
('Susan','Ellis'),
('Leslie','Stone'),
('Ron','Barnes'),
('Joyce','Johnston'),
('Elaine','Horton'),
('Ben','Carpenter'),
('Caleb','Green');

CREATE TABLE public.hw_info (
    id serial,
    name varchar(50),
    total_points INT
);
INSERT INTO public.hw_info (name, total_points) VALUES
('Homework 1', 18),
('Homework 2', 14),
('Homework 3', 20),
('Homework 4', 13),
('Homework 5', 20),
('Homework 6', 27),
('Homework 7', 20),
('Homework 8', 16),
('Quiz 1', 19),
('Quiz 2', 19),
('Quiz 3', 23);


CREATE TABLE public.submissions (
    student_id INT,
    hw_id INT,
    earned_points NUMERIC(5,2)
);
INSERT INTO public.submissions VALUES
(45,1,3),
(21,1,2),
(44,1,0),
(17,1,0),
(3,1,8),
(1,1,4),
(22,1,6),
(8,1,8),
(30,1,8),
(42,1,10),
(32,1,10),
(14,1,12),
(31,1,7),
(37,1,11),
(20,1,9),
(35,1,7),
(46,1,7),
(25,1,8),
(28,1,12),
(33,1,12),
(11,1,9),
(7,1,9),
(39,1,5),
(43,1,7),
(16,1,0),
(2,1,17),
(29,1,11),
(5,1,13),
(9,1,2),
(15,1,8),
(41,1,10),
(6,1,4),
(18,1,0),
(36,1,17),
(49,1,9),
(40,1,11),
(4,1,6),
(10,1,14),
(12,1,14),
(50,2,9),
(18,2,4),
(16,2,7),
(3,2,0),
(19,2,0),
(10,2,6),
(14,2,1),
(2,2,2),
(24,2,2),
(7,2,13),
(26,2,8),
(42,2,8),
(29,2,4),
(48,2,8),
(33,2,1),
(34,2,4),
(43,2,3),
(36,2,13),
(6,2,5),
(37,2,2),
(13,2,6),
(44,2,7),
(27,2,3),
(28,2,8),
(11,2,12),
(25,2,1),
(15,2,5),
(46,2,6),
(5,2,1),
(21,2,7),
(8,2,3),
(39,2,10),
(12,2,11),
(49,2,7),
(47,2,10),
(32,2,6),
(45,2,12),
(40,2,3),
(30,2,3),
(17,3,13),
(30,3,18),
(24,3,20),
(45,3,14),
(46,3,18),
(5,3,19),
(14,3,16),
(48,3,4),
(3,3,10),
(21,3,6),
(27,3,12),
(6,3,2),
(32,3,8),
(22,3,6),
(40,3,14),
(47,3,7),
(31,3,13),
(50,3,2),
(13,3,16),
(10,3,10),
(16,3,12),
(20,3,8),
(19,3,19),
(8,3,0),
(4,3,19),
(34,3,10),
(1,3,17),
(42,3,10),
(37,3,16),
(36,3,8),
(41,3,7),
(25,3,2),
(33,3,5),
(7,3,14),
(2,3,16),
(35,3,10),
(11,3,14),
(18,3,19),
(29,3,4),
(17,4,8),
(29,4,3),
(3,4,1),
(39,4,1),
(40,4,6),
(10,4,2),
(49,4,2),
(21,4,8),
(35,4,8),
(12,4,2),
(7,4,9),
(1,4,6),
(18,4,5),
(27,4,6),
(33,4,4),
(19,4,10),
(16,4,4),
(2,4,10),
(28,4,3),
(44,4,3),
(6,4,8),
(11,4,7),
(15,4,6),
(31,4,1),
(50,4,8),
(8,4,1),
(42,4,12),
(47,4,4),
(13,4,3),
(20,4,12),
(5,4,5),
(26,4,1),
(43,4,2),
(22,4,2),
(4,4,5),
(46,4,11),
(48,4,10),
(25,4,8),
(30,4,6),
(27,5,18),
(30,5,8),
(22,5,14),
(35,5,14),
(6,5,6),
(41,5,2),
(37,5,12),
(10,5,13),
(20,5,9),
(19,5,0),
(36,5,16),
(31,5,14),
(2,5,3),
(21,5,0),
(9,5,0),
(3,5,14),
(48,5,14),
(45,5,19),
(8,5,0),
(11,5,19),
(28,5,19),
(29,5,18),
(33,5,13),
(42,5,9),
(40,5,9),
(46,5,15),
(44,5,8),
(18,5,0),
(38,5,19),
(14,5,14),
(16,5,4),
(43,5,3),
(26,5,16),
(49,5,0),
(32,5,4),
(13,5,13),
(12,5,19),
(47,5,3),
(34,5,14),
(27,6,7),
(36,6,6),
(9,6,25),
(13,6,17),
(28,6,17),
(24,6,23),
(47,6,10),
(12,6,4),
(22,6,26),
(15,6,9),
(1,6,17),
(40,6,15),
(37,6,6),
(41,6,9),
(8,6,25),
(39,6,21),
(45,6,22),
(30,6,16),
(20,6,16),
(11,6,22),
(33,6,20),
(16,6,10),
(50,6,5),
(31,6,24),
(29,6,26),
(42,6,12),
(44,6,12),
(48,6,19),
(34,6,4),
(49,6,1),
(32,6,5),
(26,6,14),
(2,6,21),
(3,6,1),
(43,6,23),
(18,6,26),
(21,6,5),
(38,6,14),
(25,6,12),
(7,7,8),
(8,7,1),
(20,7,3),
(12,7,5),
(11,7,8),
(29,7,11),
(50,7,5),
(34,7,16),
(14,7,13),
(16,7,4),
(40,7,10),
(27,7,9),
(15,7,13),
(9,7,4),
(38,7,12),
(31,7,4),
(32,7,6),
(41,7,13),
(4,7,12),
(19,7,7),
(48,7,0),
(18,7,7),
(5,7,2),
(13,7,14),
(35,7,1),
(47,7,10),
(30,7,15),
(3,7,3),
(44,7,3),
(49,7,4),
(17,7,1),
(2,7,8),
(36,7,8),
(37,7,2),
(26,7,3),
(39,7,7),
(24,7,13),
(42,7,5),
(25,7,6),
(25,8,10),
(8,8,12),
(20,8,6),
(9,8,7),
(47,8,3),
(2,8,2),
(4,8,1),
(1,8,1),
(19,8,6),
(31,8,1),
(13,8,15),
(10,8,14),
(16,8,11),
(26,8,17),
(3,8,11),
(34,8,8),
(22,8,16),
(5,8,11),
(48,8,18),
(43,8,9),
(32,8,10),
(39,8,17),
(40,8,1),
(28,8,4),
(11,8,11),
(35,8,6),
(41,8,11),
(37,8,12),
(12,8,9),
(6,8,15),
(18,8,7),
(33,8,7),
(15,8,2),
(29,8,16),
(49,8,6),
(27,8,8),
(46,8,8),
(30,8,1),
(42,8,2),
(10,9,17),
(22,9,7),
(49,9,12),
(27,9,13),
(21,9,6),
(41,9,6),
(17,9,7),
(5,9,12),
(45,9,13),
(36,9,15),
(39,9,18),
(6,9,18),
(7,9,10),
(1,9,1),
(15,9,18),
(12,9,16),
(20,9,17),
(28,9,5),
(29,9,1),
(40,9,0),
(19,9,12),
(25,9,3),
(34,9,18),
(50,9,7),
(13,9,11),
(18,9,1),
(9,9,1),
(24,9,10),
(32,9,9),
(26,9,14),
(48,9,4),
(3,9,14),
(35,9,14),
(4,9,9),
(43,9,18),
(2,9,9),
(47,9,3),
(38,9,6),
(14,9,11),
(44,9,9),
(26,10,10),
(2,10,11),
(50,10,15),
(15,10,13),
(20,10,16),
(42,10,22),
(17,10,13),
(11,10,10),
(37,10,0),
(10,10,6),
(21,10,7),
(12,10,13),
(9,10,3),
(38,10,20),
(7,10,19),
(31,10,8),
(19,10,21),
(34,10,18),
(44,10,12),
(14,10,16),
(36,10,10),
(43,10,18),
(46,10,4),
(39,10,19),
(28,10,22),
(25,10,19),
(3,10,9),
(32,10,15),
(4,10,7),
(5,10,9),
(24,10,23),
(49,10,11),
(8,10,10),
(22,10,21),
(27,10,9),
(45,10,2),
(1,10,21),
(33,10,16),
(16,10,18);

