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 THE SQL TO SOLVE: AND THE SCHEMA IS IN THE UP:

QUESTION 1 0.5 points Save Answer Download ClassGrades.txt, from the Exam 01 folder, and execute each SQL statement as instructed in the file. Answer the following four questions: (1) On E01 (Exam 01), which two students are tied for the 101 highest grade in the class? (Hint Write a query to determine the order and then look at the results, given the order the query gives you) Kathryn & Sarah Ryan & Alexandria Ryan & Emily Emily & Carlos Save Answer QUESTION 2 O points Below, paste the SQL you wrote to answer question ta. Although this question is worth 0 points, if it is blank there will be a 0.5 point deduction if the question to which tapplies is correct For the toolbar, press ALT F10 (PC) or ALT-FN-F10 (Mac) BI VS Paragraph Arial 14px A2 I %99 & TT 12 (1) + +