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

Lukasz Walczak
Lukasz Walczak
6,620 Points
Posted by Lukasz Walczak
Lukasz Walczak
6,620 Points

Did you select from "users" table? I DID :)

SELECT first_name, last_name FROM users WHERE id = 'wig_lady';

first_name last_name

that's the result of my query it looks fine to me

any ideas what might be wrong here

1 Answer

Jennifer Nordell
seal-mask
STAFF
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher
Jennifer Nordell
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher

Hi there! This error might be a bit hard to figure out. Yes, you selected from the users table, but the challenge asks you to return the results where the username is equal to "wig_lady", but you're comparing it to the id.

Hope this helps! :sparkles:

edited for additional note

I believe you're referring to this challenge

Lukasz Walczak
Lukasz Walczak
6,620 Points
Lukasz Walczak
Lukasz Walczak
6,620 Points

It seems that I have been deceived by the SQL Playground :) And myself too ;)

Many thanks for help!