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 SQL Basics Finding the Data You Want Searching Tables with 'WHERE'

Claire Uzenski
Claire Uzenski
1,026 Points
Posted by Claire Uzenski
Claire Uzenski
1,026 Points

How do i complete the equation

I don't know what I'm doing wrong, I don't know what I'm missing from the equation. I feel like I type it right, but then it says I didn't or I'm missing something

Claire Uzenski
Claire Uzenski
1,026 Points
Claire Uzenski
Claire Uzenski
1,026 Points

I'm doing Beginning SQL by the way

Elijah Quesada
.a{fill-rule:evenodd;}techdegree seal-36
Elijah Quesada
Front End Web Development Techdegree Graduate 32,965 Points

Post your answer.

1 Answer

Joseph Yhu
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Joseph Yhu
PHP Development Techdegree Graduate 48,637 Points
Joseph Yhu
.a{fill-rule:evenodd;}techdegree seal-36
Joseph Yhu
PHP Development Techdegree Graduate 48,637 Points

For the first part, you have to select first and last names from users that have the username of "wig_lady."

SELECT first_name, last_name FROM users WHERE username = "wig_lady"

For the second part, you have to select all columns from products that don't have the price of 9.99.

SELECT * FROM products WHERE price != 9.99

For the last part, you have to select usernames from users with the last name of "Chalkley."

SELECT username FROM users WHERE last_name = "Chalkley"