Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

SQL Reporting by Example

Well done!

You have completed SQL Reporting by Example!

Sign up for Treehouse Back to Library

7th Grade Science

1:57 with Ben Deitch

Which teacher teaches 7th grade science?

This video doesn't have any notes.

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    Can you figure out who teaches seventh grade science so 0:00
    he can get them a fruit basket too? 0:01
    >> This query is gonna be pretty similar to the last one. 0:04
    So to make it seem a little different, I'm going to do this from 0:07
    the perspective of the subjects table instead of the teachers table. 0:10
    So let's start by selecting everything from the subjects table and 0:14
    then join to the classes table. 0:19
    And we'll join it on SUBJECTS.ID = CLASSES.SUBJECT_ID. 0:21
    Then from here, we'll need to 0:28

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up