Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed SQL Reporting by Example!
You have completed SQL Reporting by Example!
Preview
Which subject/s are taught in the largest room?
This video doesn't have any notes.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
the rooms table.
0:00
And to do that,
we can use the classes table.
0:00
The CLASSES table has both the SUBJECT_ID
column and a ROOM_ID column.
0:03
So, let's start by
selecting everything from
0:08
the classes table WHERE
the ROOM_ID is = to 19.
0:13
Then from here,
we need to join to the subjects table, so
0:19
we can resolve these subjects into
whatever subjects they actually are.
0:22
So to do this, we're going to join from,
0:27
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up