Please solve it in SQL

This is the ClassGrade SCHEMA:

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);

QUESTION 3 0.5 points 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 Malorie O Brendan QUESTION 4 O points Se 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 if the question to which it applies is co For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BI V S Paragraph Arial 14px TK % D a