Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Databases SQL Basics Finding the Data You Want Searching Tables with 'WHERE'

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

I'm doing Beginning SQL by the way

Post your answer.

1 Answer

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"