🤑 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
  • Rojina Pradhan
    Rojina Pradhan
    2,681 Points

    We're back using the e-commerce database. I only have 10.99 left in my bank account. Write a query that will return all

    Posted October 2, 2023 6:05pm by Rojina Pradhan
    Rojina Pradhan
    2,681 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    3 Answers

  • Omolade Akinwumi
    Omolade Akinwumi
    1,068 Points

    WHERE CONDITION

    Posted March 25, 2022 8:33am by Omolade Akinwumi
    Omolade Akinwumi
    1,068 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    2 Answers

  • Lacey Walker
    Lacey Walker
    294 Points

    It's saying I'm not selecting from the results table when I am

    Posted December 14, 2021 7:27pm by Lacey Walker
    Lacey Walker
    294 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    1 Answer

  • João Mendonça
    João Mendonça
    2,793 Points

    Stuck on SQL question, did I not SELECT?

    Posted October 4, 2021 11:36am by João Mendonça
    João Mendonça
    2,793 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    1 Answer

  • Shain Jones
    Shain Jones
    1,315 Points

    seems to be simple but I am missing something. task is get results of home team scores <=. Not liking my syntax

    Posted August 28, 2020 2:06pm by Shain Jones
    Shain Jones
    1,315 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    1 Answer

  • Joe Li
    Joe Li
    3,234 Points

    What column am I missing from my query?

    Posted May 28, 2020 4:34pm by Joe Li
    Joe Li
    3,234 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    2 Answers

  • Richard Sun
    Richard Sun
    11,257 Points

    What is wrong with this query?

    Posted March 14, 2020 11:19pm by Richard Sun
    Richard Sun
    11,257 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    1 Answer

  • mihneaburtescu
    mihneaburtescu
    348 Points

    I dont understand

    Posted February 28, 2020 5:02am by mihneaburtescu
    mihneaburtescu
    348 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    1 Answer

  • vona goodpaster
    vona goodpaster
    1,719 Points

    keeps stating: Did you select from "results" table My answer: SELECT * FROM results WHERE away_team < 10;

    Posted January 6, 2020 8:22pm by vona goodpaster
    vona goodpaster
    1,719 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    1 Answer

  • vona goodpaster
    vona goodpaster
    1,719 Points

    system states this is incorrect: select * from results where home_team > 12;

    Posted January 6, 2020 8:09pm by vona goodpaster
    vona goodpaster
    1,719 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    1 Answer

  • Dominick Brady
    Dominick Brady
    2,319 Points

    SELECT * FROM home_team WHERE home_score > 12; Is there a syntax error with the query? I don't understand the issue.

    Posted December 2, 2019 8:42pm by Dominick Brady
    Dominick Brady
    2,319 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    2 Answers

  • Remi Vledder
    Remi Vledder
    14,144 Points

    It's not clear in the question that all columns should be selected.

    Posted July 24, 2019 9:01am by Remi Vledder
    Remi Vledder
    14,144 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    0 Answers

  • gerardo keys
    gerardo keys
    14,292 Points

    These challenges will not submit

    Posted July 21, 2019 8:39pm by gerardo keys
    gerardo keys
    14,292 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    2 Answers

  • Michelle Clark
    Michelle Clark
    1,032 Points

    I am selecting all columns from the products table (id, name, description, price) but not registering in exercise...

    Posted May 1, 2019 2:26pm by Michelle Clark
    Michelle Clark
    1,032 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    2 Answers

  • Ben Brown
    Ben Brown
    799 Points

    I am typing in results for the Table, but it is saying that I am not selecting from the results table

    Posted December 13, 2018 3:58pm by Ben Brown
    Ben Brown
    799 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    1 Answer

  • Brandy Steals
    PLUS
    Brandy Steals
    Courses Plus Student 5,457 Points

    Did you select from the 'results' table error message

    Posted October 27, 2018 1:37am by Brandy Steals
    Brandy Steals
    Courses Plus Student 5,457 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    1 Answer

  • Fairooz Adams
    Fairooz Adams
    2,704 Points

    Problem with code.

    Posted September 28, 2018 9:22pm by Fairooz Adams
    Fairooz Adams
    2,704 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    1 Answer

  • Ruchi P
    Ruchi P
    123 Points

    We have a database that runs a sports team's website. In the results table we have the columns id, home_team, home_score

    Posted August 21, 2018 7:24am by Ruchi P
    Ruchi P
    123 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    1 Answer

  • Shain Jones
    Shain Jones
    1,315 Points

    the code challenge is asking if I "selected results as my table." My code is SELECT * FROM results WHERE away_team<10;

    Posted August 16, 2018 7:04pm by Shain Jones
    Shain Jones
    1,315 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    3 Answers

  • MUSTAFA TAHA
    MUSTAFA TAHA
    5,150 Points

    why when I write this come I get error what is the wrong? SELECT * FROM results WHERE home_team > 12;

    Posted July 25, 2018 8:05pm by MUSTAFA TAHA
    MUSTAFA TAHA
    5,150 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    2 Answers

  • A X
    A X
    12,842 Points

    Discovered bug in Filtering by comparing columns Challenge Task

    Posted January 17, 2016 10:08pm by A X
    A X
    12,842 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values

    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.