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
Sorie Kabba
Courses Plus Student 744 PointsWRONG Question or WRONG Answer
SELECT * FROM phone_book WHERE last_name IS NOT NULL;
3 Answers
bothxp
16,510 PointsHi Sorie,
Are you answering Filtering Out or Finding Missing Information, Challenge Task 2 of 2
"We're still using the phone_book, with the columns id, first_name, last_name and phone.
Imagine we're implementing the autocomplete feature for a search facility on the phone where a user can start typing a last name and suggestions will appear. Write a query to retrieve all values from the last name column where the last name value is present. Only retrieve the last_name column."
In which case it is asking you to only select the last_name column, not all of them.
Sobin Sebastian
5,348 PointsSELECT last_name FROM phone_book WHERE last_name IS NOT NULL;
It specifically says "Only retrieve the last_name column"
Cena Mayo
55,236 PointsThanks guys! Not my question, but was about to ask the same one. Details, they're important! :)
Jason Anello
Courses Plus Student 94,610 PointsJason Anello
Courses Plus Student 94,610 PointsWhich challenge are you on?