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

Posted by AJ Nunez
AJ Nunez
Courses Plus Student 1,269 Points

Can you tell me what am I missing here in this SQL query? please

I'm getting an incorrect answer at the phone_book table....

select * from phone_book where last_name is not null;

I think I've chosen the check box to add my code, so here...

redcamel2
redcamel2
4,751 Points

Please post your code. we can't help you if you don't.

redcamel2
redcamel2
4,751 Points

Which code challenge are you stuck on?

AJ Nunez
AJ Nunez
Courses Plus Student 1,269 Points

I'm at the Filtering Out or Finding Missing Information

4 Answers

redcamel2
redcamel2
4,751 Points

Your syntax is right but at the end they ask for you to only retrieve the last_name

So it should be like this 

select last_name from phone_book where last_name is not null;

Hope this helps and if it does please make this best answer.

AJ Nunez
AJ Nunez
Courses Plus Student 1,269 Points

I've tried this but I'm getting this result

Bummer! You didn't select all columns. Get Help Try Again

select last_name from phone_book where last_name is not null;

last_name Holligan Kozup Chalkley McFarland Luna

Jason Anello
Jason Anello
Courses Plus Student 94,610 Points

Are you on task 1 or 2?

redcamel2
redcamel2
4,751 Points

If your on task 1 the code should be this

select * from phone_book where phone is null;

If your on task 2 the code should be this

select last_name from phone_book where last_name is not null;

Please make this the best answer.

redcamel2
redcamel2
4,751 Points
redcamel2
redcamel2
4,751 Points

Then the answer is this

select * from phone_book where phone is null;

Please make this the best answer.

AJ Nunez
PLUS
AJ Nunez
Courses Plus Student 1,269 Points
AJ Nunez
AJ Nunez
Courses Plus Student 1,269 Points

Challenge Task 1 of 2

AJ Nunez
PLUS
AJ Nunez
Courses Plus Student 1,269 Points
AJ Nunez
AJ Nunez
Courses Plus Student 1,269 Points

Thanks all...

redcamel2
redcamel2
4,751 Points

Please make my answer the best!!!!

redcamel2
redcamel2
4,751 Points

Thanks!!!