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 Modifying Data with SQL Deleting Data From a Database Deleting Data With SQL

Hasan Ali
Hasan Ali
2,039 Points
Posted by Hasan Ali
Hasan Ali
2,039 Points

Not sure where i am going wrong

can anyone help me i do not know where I am going wrong.

Randy Layne
.a{fill-rule:evenodd;}techdegree seal-36
Randy Layne
Treehouse Moderator

Hi Hasan!

Would you mind posting what you've tried and we'll be more than happy to point you in the right direction! ;)

As a general info thing, make sure you are checking that the price is greater than 11 and not products

3 Answers

Randy Layne
seal-mask
MOD
.a{fill-rule:evenodd;}techdegree seal-36
Randy Layne
Treehouse Moderator
Randy Layne
.a{fill-rule:evenodd;}techdegree seal-36
Randy Layne
Treehouse Moderator

Hi saadmeah!

When looking at your answers for Q2 and Q3 I noticed that the quotation marks being used are different between the two. Sure enough when I paste in your answer for Q3 as is, it fails, but if I paste it in and then change the quotation marks it works!

Hope this helps!

saad
saad
26,165 Points
saad
saad
26,165 Points

Hi!

Q1: DELETE FROM products WHERE price >= 11;

Q2: DELETE FROM users WHERE username = "poley_hands";

Q3: DELETE FROM phone_book WHERE first_name = “Jonathan” AND last_name = “Luna”;

Q1 and Q2 are correct, but for Q3 I can’t seem to get it right.

saad
saad
26,165 Points
saad
saad
26,165 Points

Thank you Randy :)

Q3 is now passed!