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 students have 5th period science and 7th period art?
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
And I think it has to do with a student
who has fifth period science and
0:00
seventh period art.
0:01
Can you figure out which students
have fifth period science and
0:02
seventh period art?
0:05
To figure out which students have fifth
period science and seventh period art,
0:07
a good approach would be to get a data
set of fifth period science students.
0:11
And a separate data set of
7th period art students and
0:15
then to join them and
see what's inside the inner section.
0:18
So let's start by figuring out which
students have fifth period science.
0:22
So let's select everything
from the student's table.
0:26
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