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

Maureen O'Neal
Maureen O'Neal
12,930 Points
Posted by Maureen O'Neal
Maureen O'Neal
12,930 Points

SQL Basics challenge 2 of 2

Again , it seems a simple question:

SQL Basics challenge 2 of 2 Again , it seems a simple question: We're back on the smartphone, but our phone_book is a mess. There's a phone_book table but there's missing information in a couple of the columns. The phone_book has the following columns id, first_name, last_name and phone. Find all contacts in the phone_book where the phone number is missing so we can go and ask them for their number. And my answer doesn't pass. My code: SELECT * FROM phone_book WHERE last_name IS NOT NULL; What am I doing WRONG! ?!

3 Answers

Maureen O'Neal
Maureen O'Neal
12,930 Points
Maureen O'Neal
Maureen O'Neal
12,930 Points

Never mind, I found it ALREADY in community questions and answers , should have looked there first!

Adriano De Oliveira
Adriano De Oliveira
5,653 Points

hi, Maureen ! my cody is not passing, can you send me yours, and where are the community question and answers? thank you.

Sobin Sebastian
Sobin Sebastian
5,348 Points
Sobin Sebastian
Sobin Sebastian
5,348 Points

SELECT * FROM phone_book WHERE phone IS NULL;