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

1 Answer

Joseph Yhu
Joseph Yhu
PHP Development Techdegree Graduate 37,472 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"