SQL Notation: Answer the following 3 questions using SQL notation:

After creating table E with query: CREATE TABLE E (roster varchar(3),gender char(1),course varchar(15),grades int);

and populating the table with the following data:

INSERT INTO E VALUES ('S01','F','PHYSICS',95) INSERT INTO E VALUES ('S02','M','ALGEBRA',82) INSERT INTO E VALUES ('S03','M','ALGEBRA',87) INSERT INTO E VALUES ('S04','M','BIOCHEM',94) INSERT INTO E VALUES ('S05','M','CALCULUS',96) INSERT INTO E VALUES ('S06','F','PHYSICS',85) INSERT INTO E VALUES ('S07','F','ALGEBRA',94) INSERT INTO E VALUES ('S08','M','ALGEBRA',91) INSERT INTO E VALUES ('S09','M','CALCULUS',86) INSERT INTO E VALUES ('S10','M','CALCULUS',86) INSERT INTO E VALUES ('S11','F','ALGEBRA',95) INSERT INTO E VALUES ('S12','F','BIOCHEM',86) INSERT INTO E VALUES ('S02','F','PHYSICS',95) INSERT INTO E VALUES ('S08','M','PHYSICS',82) INSERT INTO E VALUES ('S01','M','ALGEBRA',87) INSERT INTO E VALUES ('S05','M','BIOCHEM',84) INSERT INTO E VALUES ('S12','M','CALCULUS',94) INSERT INTO E VALUES ('S10','F','PHYSICS',96) INSERT INTO E VALUES ('S06','F','ALGEBRA',85) INSERT INTO E VALUES ('S02','M','CALCULUS',94) INSERT INTO E VALUES ('S06','M','CALCULUS',91) INSERT INTO E VALUES ('S11','M','CALCULUS',86) INSERT INTO E VALUES ('S04','F','ALGEBRA',95) INSERT INTO E VALUES ('S06','F','BIOCHEM',86)

1)from table E, for each course list course,maximum grade

2) from table E, for each course list course, the student that Scored the highest score.

3)from table E, list students who have scored the highest grade in more than one course.