Skip to main content

Notice: Workspaces are undergoing maintenance and are temporarily unavailable.

🚀 In our NEW AI Bootcamp you'll build a working app in 28 days, no experience required. Free to all subscription levels.

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

Join the Treehouse affiliate program and earn 25% recurring commission! 🤑

  • Treehouse Logo
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
    • All Courses
    • Tracks
    • AI Bootcamp
    • College Credit
    • Techdegree Bootcamps
    • Front End Development
    • Full Stack JavaScript
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
    • Explore
    • Career Toolbox
    • Free Treehouse Near Me
    • Affiliates
    • Blog
    • Support
    • About
    • Learn
    • Beginner's Guide to Coding
    • Data Analysis with SQL & Python
    • Front-End Web Development
    • Python Programming Basics
    • Techdegree Bootcamp Overview
    • UX Design Fundamentals
    • AI Tools for Beginners
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks AI Bootcamp College Credit
  • Techdegree Bootcamps Front End Web Development Full Stack JavaScript
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Explore Career Toolbox Free Treehouse Near Me Affiliates Blog Support About
    Learn Beginner's Guide to Coding Data Analysis with SQL & Python Front-End Web Development Python Programming Basics Techdegree Bootcamp Overview UX Design Fundamentals AI Tools for Beginners
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
Loading banner... Start your free trial at Treehouse
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • APIs
      • • Coding for Kids
      • • College Credit
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Game Development
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • No-Code
      • • PHP
      • • Professional Growth
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
      • • Swift
      • • Vibe Coding
  • abdel ahbe
    seal-mask
    PLUS
    .a{fill-rule:evenodd;}techdegree
    abdel ahbe
    Python Development Techdegree Student 2,125 Points

    I believe the solution provided in the video is not correct!

    Posted January 7, 2025 9:08am by abdel ahbe
    .a{fill-rule:evenodd;}techdegree
    abdel ahbe
    Python Development Techdegree Student 2,125 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 8th Grade Teachers

    1 Answer

  • Alex Hort-Francis
    Alex Hort-Francis
    12,924 Points

    On the `DISTINCT` keyword per column in the instructor's example query

    Posted October 15, 2023 3:42pm by Alex Hort-Francis
    Alex Hort-Francis
    12,924 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 8th Grade Teachers

    1 Answer

  • Rushabha Jain
    seal-mask
    PLUS
    .a{fill-rule:evenodd;}techdegree
    Rushabha Jain
    Front End Web Development Techdegree Student 9,859 Points

    cte vs join performance

    Posted April 18, 2021 7:01am by Rushabha Jain
    .a{fill-rule:evenodd;}techdegree
    Rushabha Jain
    Front End Web Development Techdegree Student 9,859 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    1 Answer

  • Jordan young
    PLUS
    Jordan young
    Courses Plus Student 5,277 Points

    Hi. I did a totally different query, but generated the same result. Is there a preference for either method?

    Posted September 24, 2020 3:02pm by Jordan young
    Jordan young
    Courses Plus Student 5,277 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    1 Answer

  • Michael Hill
    Michael Hill
    3,960 Points

    My Solution to this Challenge

    Posted May 17, 2020 5:13pm by Michael Hill
    Michael Hill
    3,960 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Subjects in the Big Room

    1 Answer

  • Frances Angulo
    Frances Angulo
    5,311 Points

    My solution returned more results

    Posted January 25, 2020 4:02pm by Frances Angulo
    Frances Angulo
    5,311 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 8th Grade Teachers

    3 Answers

  • Ronald Greer
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Ronald Greer
    Front End Web Development Techdegree Graduate 56,430 Points

    I thought that the answer to the first fill in the blank was "* FROM". what am i doing wrong?

    Posted December 29, 2019 4:00pm by Ronald Greer
    .a{fill-rule:evenodd;}techdegree seal-36
    Ronald Greer
    Front End Web Development Techdegree Graduate 56,430 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    1 Answer

  • kevin hudson
    PLUS
    kevin hudson
    Courses Plus Student 11,987 Points

    Is it a bad approach to use subqueries over CTE and JOINING?

    Posted April 8, 2019 6:20pm by kevin hudson
    kevin hudson
    Courses Plus Student 11,987 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    2 Answers

  • Harris Handoko
    Harris Handoko
    3,932 Points

    Question on order of joining tables

    Posted February 3, 2019 11:34pm by Harris Handoko
    Harris Handoko
    3,932 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    2 Answers

  • Fairooz Adams
    Fairooz Adams
    2,704 Points

    Quiz Question Issues

    Posted October 14, 2018 11:16pm by Fairooz Adams
    Fairooz Adams
    2,704 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    3 Answers

  • Fairooz Adams
    Fairooz Adams
    2,704 Points

    Quiz Question Issues

    Posted October 14, 2018 11:14pm by Fairooz Adams
    Fairooz Adams
    2,704 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    1 Answer

  • Olutope Ayorinde
    Olutope Ayorinde
    2,875 Points

    highest employee salary challenge

    Posted April 13, 2018 6:44pm by Olutope Ayorinde
    Olutope Ayorinde
    2,875 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    1 Answer

  • Olutope Ayorinde
    Olutope Ayorinde
    2,875 Points

    returning 1 row per employee

    Posted April 13, 2018 6:41pm by Olutope Ayorinde
    Olutope Ayorinde
    2,875 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    2 Answers

  • Maxine Lewis
    Maxine Lewis
    2,043 Points

    What should be added to this query to only return 1 row per employee

    Posted January 22, 2018 10:38am by Maxine Lewis
    Maxine Lewis
    2,043 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    1 Answer

  • Donnie Driskell
    Donnie Driskell
    2,243 Points

    Reporting by example: 8th Grade Teachers. (my solution)

    Posted January 1, 2018 5:19am by Donnie Driskell
    Donnie Driskell
    2,243 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 8th Grade Teachers

    2 Answers

  • Rick Garland
    Rick Garland
    2,738 Points

    MATH VALUES

    Posted December 24, 2017 12:09am by Rick Garland
    Rick Garland
    2,738 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    1 Answer

  • Bruce McMinn
    Bruce McMinn
    10,030 Points

    A different approach and learning about JOIN

    Posted August 7, 2017 8:10pm by Bruce McMinn
    Bruce McMinn
    10,030 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Subjects in the Big Room

    4 Answers

  • Andrew Federico
    Andrew Federico
    7,990 Points

    Bug in quiz

    Posted August 4, 2017 1:58pm by Andrew Federico
    Andrew Federico
    7,990 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    1 Answer

  • György Varga
    György Varga
    19,198 Points

    Case sensitivity

    Posted July 28, 2017 6:39am by György Varga
    György Varga
    19,198 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    2 Answers

  • György Varga
    György Varga
    19,198 Points

    Wasn't the question: 'Which subjects are taught in the largest room?'

    Posted July 27, 2017 2:32pm by György Varga
    György Varga
    19,198 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Subjects in the Big Room

    1 Answer

  • Greg Kaleka
    Greg Kaleka
    39,021 Points

    Even More Subqueries!

    Posted July 21, 2017 9:59pm by Greg Kaleka
    Greg Kaleka
    39,021 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Elective Teachers

    2 Answers

  • Greg Kaleka
    Greg Kaleka
    39,021 Points

    More Subqueries!

    Posted July 21, 2017 9:46pm by Greg Kaleka
    Greg Kaleka
    39,021 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    4 Answers

  • Greg Kaleka
    Greg Kaleka
    39,021 Points

    The Solution Provided Doesn't Work if Teachers Teach More Than One Grade

    Posted July 21, 2017 9:29pm by Greg Kaleka
    Greg Kaleka
    39,021 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 8th Grade Teachers

    4 Answers

  • Greg Kaleka
    Greg Kaleka
    39,021 Points

    Here's a slightly more complex but more dynamic solution.

    Posted July 21, 2017 7:51pm by Greg Kaleka
    Greg Kaleka
    39,021 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • The Biggest Room

    7 Answers

  • Jackson Cromer
    Jackson Cromer
    7,548 Points

    SQL Playground Issue

    Posted July 20, 2017 5:38pm by Jackson Cromer
    Jackson Cromer
    7,548 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 8th Grade Teachers

    4 Answers

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
SEE ALL

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
SEE ALL

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
SEE ALL

About Us

  • About
  • Blog
  • Community
  • Stories
  • Contact
  • Gift Card

Explore

  • Plans
  • Affiliates
  • Perks
  • Shop
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses

Treehouse is an online technology education platform founded in 2011. Treehouse offers more than 700 self-paced, video-based courses in web development, programming, data analysis, design, and AI, plus two project-based bootcamp programs in Front End Web Development and Full Stack JavaScript. Individual Treehouse plans start at $25 per month and include a 7-day free trial. Treehouse serves individual learners, businesses, schools, and public libraries. Cardholders at participating U.S. public libraries can use Treehouse for free. Select Treehouse courses, offered with University Pathways International, are recommended for college credit by ACE and NCCRS. Treehouse learners earn digital certificates for completed Tracks.

Terms & Conditions · Privacy · © 2026 Treehouse Island, Inc.
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
  • Discord