STUDENT

$\backslash$table$[[$ST ID$,$ST NAME$],[7007,$James Bond$],[1313,$Susan Brown$],[5050,$Susan Smith$],[8989,$Megan Black$]]$

COURSE

$\backslash$table$[[$COURSE$\_$ID$,$COURSE$\_$ITIL,CREDIT$\_$HR$],[$COMP$302,$Database Systems,$3],[$COMP$203,$Computer Organization,$4],[$COMP$206,$Data Structures,$4],[$COMP$442,$Advanced Database Systems,$3]]$

ENROLLMENT

$\backslash$table$[[$ST$\_$ID$,$COURSE$\_$ID$,$GRADE$],[7007,$COMP$203,$A $+],[7007,$COMP$206,$A $+],[7007,$COMP$302,$A $+],[7007,$COMP$442,],[1313,$COMP$203,$A $+],[1313,$COMP$302,$B $+],[5050,$COMP$203,$C$+],[1313,$COMP$442,]]$

SPORT

$\backslash$table$[[$ST$\_$ID$,$SPORT$\_$NAME$],[1313,$Basketball$],[1313,$Football$],[5050,$Basketball$],[8989,$Basketball$],[1313,$Tennis$],[7007,$Soccer$],[7007,$Football$]]$

e$)$ Write the SQL statement that displays the following report as it appears below.

$\backslash$table$[[$Sport$,$Number of Students$],[$Basketball$,3],[$Football$,2],[$Tennis$,1],[$Soccer$,1]]$

$$

f$)$ Write the SQL statement that displays the number of students who play basketball and are enrolled in Database Systems.

g$)$ Consider the following SQL statementExplain in English what this statement means