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

New No-Code Track! 🚀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
    • 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
  • 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
    • Showing results for:
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Review and Practice
    • Close
  • Fred Russell
    Fred Russell
    1,545 Points

    Join returning seemingly too many (duplicate) rows.

    Posted on Mar 1, 2022 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 on Mar 1, 2021 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 on Nov 17, 2019 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 on Jan 13, 2019 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 on Dec 31, 2018 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 on Sep 13, 2018 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 on Jun 27, 2018 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 on May 31, 2017 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 on May 15, 2017 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 on Apr 12, 2017 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 on Feb 5, 2017 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 on Oct 3, 2016 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 on Sep 12, 2016 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.