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

New No-Code Track! 🚀 New videos dropping every week—start learning today!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

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

  • Treehouse Logo
  • Plans
    Chevron
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
  • Library
    Chevron
    • All Courses
    • Tracks
    • College Credit
  • Techdegree
    Chevron
    • Overview
    • Front End Development
    • Full Stack JavaScript
    • Data Analysis
    • UX Design
    • Python
  • Community
    Chevron
    • Community Projects
    • Live Sessions
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
  • Resources
    Chevron
    • Career Toolbox
    • CodeForward
    • Free Treehouse Near Me
    • Jobs
    • Blog
    • Support
    • About
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks College Credit
  • Overview Front End Web Development Full Stack JavaScript Python Development Data Analysis UX Design
  • Community Projects Live Sessions Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Career Toolbox CodeForward Free Treehouse Near Me Jobs Blog Support About
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • Android
      • • 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
  • Fred Russell
    Fred Russell
    1,545 Points

    Join returning seemingly too many (duplicate) rows.

    Posted March 1, 2022 4:07pm by Fred Russell
    Fred Russell
    1,545 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Review and Practice

    1 Answer

  • jun cheng wong
    jun cheng wong
    17,021 Points

    Task #3

    Posted March 1, 2021 3:08pm by jun cheng wong
    jun cheng wong
    17,021 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Review and Practice

    1 Answer

  • Jessica Schteiden
    Jessica Schteiden
    3,254 Points

    Hey team, I tried this query out on Q3 but it didn't work. Can someone help me understand why it's breaking?

    Posted November 17, 2019 9:24pm by Jessica Schteiden
    Jessica Schteiden
    3,254 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Review and Practice

    2 Answers

  • Mark Chesney
    Mark Chesney
    11,747 Points

    SQL self join

    Posted January 13, 2019 8:50pm by Mark Chesney
    Mark Chesney
    11,747 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Review and Practice

    2 Answers

  • George May
    George May
    3,324 Points

    Answers to Review and Practice

    Posted December 31, 2018 10:46am by George May
    George May
    3,324 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Review and Practice

    3 Answers

  • Ethan Martin
    PLUS
    Ethan Martin
    Courses Plus Student 1,883 Points

    Identifying the Patrons with outstanding Book Loans and the Count of their Outstanding Books

    Posted September 13, 2018 7:49pm by Ethan Martin
    Ethan Martin
    Courses Plus Student 1,883 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Review and Practice

    5 Answers

  • Hanna Han
    Hanna Han
    4,105 Points

    Type of relationships among three different table in Tack #3

    Posted June 27, 2018 6:21am by Hanna Han
    Hanna Han
    4,105 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Review and Practice

    1 Answer

  • Stephen Funk
    PLUS
    Stephen Funk
    Courses Plus Student 2,650 Points

    JOINS Review & Practice

    Posted May 31, 2017 6:10pm by Stephen Funk
    Stephen Funk
    Courses Plus Student 2,650 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Review and Practice

    4 Answers

  • Christian Scherer
    Christian Scherer
    2,989 Points

    Task #3 solution

    Posted May 15, 2017 2:17pm by Christian Scherer
    Christian Scherer
    2,989 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Review and Practice

    11 Answers

  • Yingzi Huang
    Yingzi Huang
    3,216 Points

    Task #1: How to count number of outstanding books each patron has and add this "COUNT" to a third column in same query?

    Posted April 12, 2017 8:34pm by Yingzi Huang
    Yingzi Huang
    3,216 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Review and Practice

    1 Answer

  • Allan Oloo
    Allan Oloo
    8,054 Points

    LEFT JOIN & RIGHT JOIN

    Posted February 5, 2017 2:56am by Allan Oloo
    Allan Oloo
    8,054 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Review and Practice

    1 Answer

  • David Wright
    David Wright
    4,437 Points

    Task #2 patrons with no loans

    Posted October 3, 2016 4:46pm by David Wright
    David Wright
    4,437 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Review and Practice

    9 Answers

  • Brendan Whiting
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Brendan Whiting
    Front End Web Development Techdegree Graduate 84,738 Points

    using the DISTINCT keyword with Task #1: "Patrons with Outstanding Loans"

    Posted September 12, 2016 11:05pm by Brendan Whiting
    .a{fill-rule:evenodd;}techdegree seal-36
    Brendan Whiting
    Front End Web Development Techdegree Graduate 84,738 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Review and Practice

    2 Answers

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

    Treehouse

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

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Affiliates
  • Perks
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2025 Treehouse Island, Inc.