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 Adriano De Oliveira
Adriano De Oliveira
5,653 Points

> SELECT last_name FROM phone_book WHERE last_name IS NOT NULL;

I would like some help to pass this challenge 1 of 2. find all contacts in the phone_book where the phone number is missing so we can go and ask them for their number.

2 Answers

Allan Clark
Allan Clark
10,810 Points
Allan Clark
Allan Clark
10,810 Points

If you want to check for the records without a phone number you need to change your where clause. You are currently checking for records that have no last name. Change 'last_name' to the phone number column and check for where it IS null.

Adriano De Oliveira
Adriano De Oliveira
5,653 Points
Adriano De Oliveira
Adriano De Oliveira
5,653 Points

thanks.