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
  • J de la Torre
    J de la Torre
    2,858 Points

    Difference in speed/efficiency between CTEs, INTERSECT, WHERE clause solutions?

    Posted August 4, 2021 7:04pm by J de la Torre
    J de la Torre
    2,858 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Finding the Troublemaker

    1 Answer

  • jun cheng wong
    jun cheng wong
    17,021 Points

    NO SUCH COLUMN: A.STUDENT_ID WHEN I RUN THIS CODE

    Posted March 4, 2021 2:40am by jun cheng wong
    jun cheng wong
    17,021 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Finding the Troublemaker

    2 Answers

  • Tommy Gebru
    Tommy Gebru
    30,164 Points

    Solution: Finding the Troublemaker

    Posted August 31, 2019 8:58pm by Tommy Gebru
    Tommy Gebru
    30,164 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Finding the Troublemaker

    1 Answer

  • Ikechukwu Arum
    Ikechukwu Arum
    5,337 Points

    ERROR: NO SUCH COLUMN

    Posted April 9, 2019 6:41pm by Ikechukwu Arum
    Ikechukwu Arum
    5,337 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Finding the Troublemaker

    3 Answers

  • Abdullah Jassim
    Abdullah Jassim
    4,551 Points

    Once the two functions: Fifth and Seventh are created, instead of using inner join, why cant we use Union ALL?

    Posted February 7, 2018 7:03pm by Abdullah Jassim
    Abdullah Jassim
    4,551 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Finding the Troublemaker

    1 Answer

  • Stephanie Marek
    Stephanie Marek
    2,831 Points

    Syntax Error Help!

    Posted January 31, 2018 4:54pm by Stephanie Marek
    Stephanie Marek
    2,831 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Finding the Troublemaker

    2 Answers

  • Stamos Bolovinos
    Stamos Bolovinos
    4,320 Points

    What's wrong with having 5th period science and 7th period art?

    Posted August 25, 2017 3:14pm by Stamos Bolovinos
    Stamos Bolovinos
    4,320 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Finding the Troublemaker

    2 Answers

  • Ruiqi Mao
    Ruiqi Mao
    16,675 Points

    My Solution without creating two common tables

    Posted July 28, 2017 4:57pm by Ruiqi Mao
    Ruiqi Mao
    16,675 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Finding the Troublemaker

    2 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