Given the table, answer the questions in SQL notation:

1) create a table E with four columns roster,gender,course,grades. Choose a domain compatible with the data Shown in the table.

2) populate the table E with the records shown in the table.

3)from table E retrieve the list of students Enrolled in BIOCHEM using SQL

4)ffrom table E, for each course list course, the number of Male students and Female students enrolled(ex: BIOCHEM F 1, BIOCHEM M 1)

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

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

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

rostergende ourse S01 S02 S03 S04 S05 S06 S07 S08 S09 S10 M S11 S12 S02 508 M S01 SOS M grades 95 PHYSICS ALGEBRA ALGEBRA BIOCHEM CALCULUS PHYSICS ALGEBRA ALGEBRA 87 94 96 85 94 91 CALCULUS86 CALCULUS88 35 86 95 82 87 94 ALGEBRA BIOCHEM PHYSICS PHYSICS ALGEBRA BIOCHEM S10 S06 S02 S06 S11 S04 S06 12 M CALCULUS96 85 94 91 86 PHYSICS ALGEBRA CALCULUS CALCULUS CALCULUS ALGEBRA BIOCHEM 95 86