Question: 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)

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:

CREATE TABLE ClassGrade ( Username VARCHAR(20), E01 INT, E02 INT, E03 INT,

QUESTIONS Print Make the SOL el you the names of the students in order of highest courage toestand the lock the list there you to determine QUESTION points are Bioeste e Sok you who won c Amoris weston is wom points to the web point deduction stone who is correct For the top ALT PALTHOM BIVS Parch BEE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!