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 trialRojina Pradhan
2,681 PointsWe'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
Treehouse StaffHey 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
2,681 PointsSELECT 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
2,681 PointsThank you Ronald ^^