Welcome to the Treehouse Community
Looking to learn something new?
Can't get this to work!
In our e-commerce database we have a users table with the columns id, username, password, first_name and last_name. Write a SQL query that retrieves the first and last names only where the username is equal to "wig_lady".
WHAT I'VE DONE: SELECT first_name, last_name WHERE username = "wig_lady";
And it won't work.
You haven't specified the table you are selecting your records from. Try:
SELECT first_name, last_name FROM users WHERE username = "wig_lady";