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

products is not passing

Challenge Task 2 of 3

In the products table we have the columns id, name, description and price. Find all products that don't have the price of 9.99. Include all columns.

Can any shed some light on why my code is not passing? Thanks!

Hi

Can you show you code?

5 Answers

Steven Parker
Steven Parker
241,970 Points

I would generally give you some hints based on your code, but this one is pretty simple. Going from that task description you should have something like this:


:warning: SPOILER ALERT


SELECT * FROM products WHERE price != 9.99;

If you have any future issues, remember to share your answer and a link to the challenge itself.

Mario Nardi
Mario Nardi
19,875 Points

I have the same problem, when I enter my code:

SELECT * FROM products WHERE price != 9.99;

I got "Bummer! You should try writing a SELECT query." response!

This is link to challenge (Challenge task 2) => Challenge task

It has to be some issue with code challenge.

SELECT *FROM products WHERE price != "9.99";

Theres different operators you can use for this challenge. For example, your code could use the ! operator, depending on what the challenge wants. Heres an example:

select * from products where price != 9.99;

Select * from products where price != 9.99