Question: I need help with these two questions below. The table structures are down below too. Provide the SQL to display each room and the total

I need help with these two questions below. The table structures are down below too.  I need help with these two questions below. The table structures
are down below too. Provide the SQL to display each room and
the total number of students who have classes in that room. The
resulting column displaying the number of students should be named "TotalStudents". You
should use only the JOI.ON.. syntax to write this query. (20 pts.)
2. Use a subquery to display the class schedule (class name, time,
and room) of history graduate student 'baker 3. Note: graduate students are
denoted by the grade level GR. (20 pts.)
image text in transcribed
image text in transcribed

Provide the SQL to display each room and the total number of students who have classes in that room. The resulting column displaying the number of students should be named "TotalStudents". You should use only the JOI.ON.. syntax to write this query. (20 pts.) 2. Use a subquery to display the class schedule (class name, time, and room) of history graduate student 'baker 3. Note: graduate students are denoted by the grade level GR. (20 pts.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!