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
Makan F
9,434 PointsI THINK THERE IS A PROBLEM WITH THE SYSTEM. I HAVE DOUBLE CHECKED THIS PROBLEM.
I think the question is not working properly.
1 Answer
Jonathan Grieve
Treehouse Moderator 91,253 PointsThanks makan,
Now this is a 2 part challenge so for now I'll assume it;s the first one you're stuck with.
You have all the fields available for you to go out. You have to return all the products between a minumum and maximum price.
select * from products WHERE price BETWEEN 10.99 AND 12.99;
So to break this down, you use SELECT * to select all the products from the products table.
Then you use the WHERE clause to get specific data. And since we're using numbers we can use the BETWEEN and AND keywords to return the data we need.
Hope this helps.
Makan F
9,434 PointsGot it. Thank you
Jonathan Grieve
Treehouse Moderator 91,253 PointsJonathan Grieve
Treehouse Moderator 91,253 PointsHi Makan,
Could you provide a link to the code challenge or the details of your question so we can have a look? Thanks :)