Consider the following database and answer the questions below.

STUDENT

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$\_$TITLE,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$]]$

a$)$ Write the SQL statement the displays the names of the students who have enrolled in the Database Systems course

Select $

From STUDENT

Where ST$\_$ID in $($Select ST$\_$ID

From ENROLLMENT$)$

b$)$ Write the SQL statement that displays a list of the students whose names start with $\text{'}$S$\text{'}$

Select $*$

From STUDENT

Where ST$\_$NAME $={?}^{\text{'}}S\%\text{'}$

c$)$ Write the SQL statement that displays the Student ID$,$ Student Name, Course ID$,$ and Grade for students that passed at least one course with a grade better than B$+($i$.$e$.$ A$-,$ A$,$ and A$+)$

Select ST$\_$ID AS STudentid, ST$\_$name As student name, Course ID$,$ Grade From

d$)$ Write the SQL statement that displays the total number of credit hours $($one number$)$ for the courses enrolled in by the student with ID $1313.$

$2$