products is not passing

Question

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!

Steven Parker · Answer

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
sql
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 · Answer

I have the same problem, when I enter my code:
mySQL
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 (https://teamtreehouse.com/library/integrating-php-with-databases/limiting-records-in-sql/filtering-data)
It has to be some issue with code challenge.

Trilok Mishra · Answer

Select * from products where price != 9.99

Cindy Lea · Answer

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;

Jamal Shiekh · Answer

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

Welcome to the Treehouse Community

Looking to learn something new?

Sofia Moshe

Sofia Moshe

products is not passing

Romain Gaget

Romain Gaget

5 Answers

Steven Parker

Steven Parker

SPOILER ALERT

Mario Nardi

Mario Nardi

Jamal Shiekh

Jamal Shiekh

Cindy Lea

Cindy Lea

Trilok Mishra

Trilok Mishra