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

🤑 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

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

  • 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
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Comparing Values
    • Close
  • 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 on Oct 2, 2023 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 on Mar 25, 2022 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 on Dec 14, 2021 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 on Oct 4, 2021 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 on Aug 28, 2020 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 on May 28, 2020 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 on Mar 14, 2020 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 on Feb 28, 2020 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 on Jan 6, 2020 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 on Jan 6, 2020 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 on Dec 2, 2019 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 on Jul 24, 2019 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 on Jul 21, 2019 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 on May 1, 2019 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 on Dec 13, 2018 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 on Oct 27, 2018 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 on Sep 28, 2018 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 on Aug 21, 2018 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 on Aug 16, 2018 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 on Jul 25, 2018 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 on Jan 17, 2016 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.