Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases SQL Basics Finding the Data You Want Filtering by Comparing Values

Posted by 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

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 products from the products table that I can afford. The columns in the products are id, name, description and price.

3 Answers

Rohald van Merode
seal-mask
STAFF
.a{fill-rule:evenodd;}techdegree
Rohald van Merode
Treehouse Staff
Rohald van Merode
.a{fill-rule:evenodd;}techdegree
Rohald van Merode
Treehouse Staff

Hey Rojina Pradhan 👋

You'll want to have a look at that query where you're selecting the columns and make sure that the column names are all comma separated instead of description and price 🙂

SELECT id, name, description, price FROM products WHERE price <= 10.99

Changing the and to be a comma should fix the issue and pass the challenge as expected 😃

Rojina Pradhan
Rojina Pradhan
2,681 Points
Rojina Pradhan
Rojina Pradhan
2,681 Points

SELECT id, name, description and price FROM products WHERE price <= 10.99

I tried using this answer but says column is missing or something

Rojina Pradhan
Rojina Pradhan
2,681 Points
Rojina Pradhan
Rojina Pradhan
2,681 Points

Thank you Ronald ^^