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
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
Get step-by-step solutions from verified subject matter experts
