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

Posted by sam john
sam john
790 Points

how to set higher than 11 one.

i dont know how to indicate the higher than 11 part.

1 Answer

bothxp
bothxp
16,510 Points
bothxp
bothxp
16,510 Points

Hi Sam,

Can you provide us with a bit more information on what you are trying to do? If you can tell use which course or challenge you are trying to complete then we'll be able to help you out.

If it's from one of the SQL courses then I'd expect you to be using the grater than sign '>' for example:

SELECT * FROM results WHERE home_score > 11;

Update:

Ok, so I think you are talking about 'Modifying Data With SQL course - Deleting Data From a Database'

Challenge Task 1 of 3, We have an eCommerce database and it has a products table. It has the columns id, name, description and price.Delete all products priced at 11 or higher!

In which case your answer should look like

DELETE FROM products WHERE price > 11;

If you are not to sure about these WHERE conditions then it might be an idea to go back and take a look at the SQL Basics course

I hope you are finding the courses useful.