CIST $1220$: SQL $$ Assign #$10$

$(40$ Points$)$

$[$More Joins $$ Chap $7]$

Using the database provided, Write and Execute SELECT statements to get the following information:

More Joins$($Multiple Table Joins$)$

$1.)$ How many Credit Hours is Debbie Gibson taking this Semester? $($Show code and answer question$)$

$2.)$ Give the name of the course, time, day and room No for all courses that Debbie Gibson is taking.

$3.)$ Do the same as #$2$ above, except for all students.

$4.)$ Give the name of the course, the number of credit hours, the name of the instructor, the time and day of the course and the roomNo for all classes taught in room $1150.$

$5.)$ What is the avg gpa for all students taking the $$Intro to Java$$ course? $($Show code and answer question$)$

$6.)$ How many students are in each course? Give course number and how many students are in each course.

$7.)$ How many students is each instructor teaching? Give instructor last name and how many students they are teaching.

$8.)$ Ms Mitchell wants a list of all the students in her classes and their email addresses.