CREATE TABLE ClassGrade ( Username VARCHAR(20), E01 INT, E02 INT, E03 INT, E04 INT, ExamAverage INT); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Brendan',78,84,65,77,76); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Dillan',72,86,86,84,82); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Colton',61,90,89,75,79); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Cameron',92,98,99,91,95); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Steven',69,101,99,100,92); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Austin',77,88,82,75,81); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Adrienne',90,87,89,91,89); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Brenna',66,61,62,66,64); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Malorie',66,67,66,92,73); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Corey',67,63,62,0,48); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Alexandria',81,94,66,88,82); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Kathryn',41,0,0,0,10); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Sue',74,86,69,99,82); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Jordanne',83,92,94,96,91); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Emily',95,102,89,75,90); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Dylan',62,79,56,92,72); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Ryan',95,104,98,75,93); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('James',58,54,71,71,64); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Bo',84,95,88,88,89); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Carlos',81,92,88,94,89); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Sarah',41,61,43,0,36); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Dennis',71,62,78,85,74); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Kody',69,76,89,71,76); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Bill',79,74,71,73,74); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Angelica',89,78,86,88,85); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Aric',88,99,88,97,93); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Kevin',80,86,84,94,86); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Ryan',86,88,93,96,91); INSERT INTO ClassGrade (Username, E01, E02, E03, E04, ExamAverage) VALUES ('Matthew',33,63,0,0,24);

USE SQL TO SOLVW THW QUESTION, AND THE SCHEMA IS IN THE UP:

QUESTION 3 0.5 points Save Answer Which student had the 7th lowest grade on E03 Do not simply change Question 1a SQL to return E03 results and then count from the bottom. The SQL is similar but think about how to show the results from worst score to best score O Sue O Dennis O Malone O Brendan QUESTION 4 0 points Save Answer 2 Below, paste the SQL you wrote to answer question 1b. Although this question is worth 0 points, if it is blank there will be a 0,5 point deduction is the question to which it applies is correct. For the toolbar, press ALT+F 10 (PC) or ALT+FN+F10 (Mac). BI U & Paragraph Arial 14px A I. OQS x? X 1 5 | [+ 8 38 G O WORDS POWERED BY TINY