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 THE QUESTION, AND THE SCHEMA IS IN UP:

QUESTION Wie a query plays the students and the trade Escort Based on the following business 1. Above and A 3 Abowe 70 and 30 & Above 60 and Declay the son om AFNOT ned by E2 - Byltede Paste SOL, you will neerges below For the trobar pe A.T-F10PC) ALTEN F10 BIUS Payah PE 5 WERDEN