Databases SQL Basics Finding the Data You Want Filtering Out or Finding Missing Information

Cosmin Iuga
Cosmin Iuga
2,352 Points

I'm stuck here. please help

I'm stuck here. Please help.

SELECT phone_book WHERE last_name =%% AND last_name IS NOT NULL;

4 Answers

Cosmin Iuga
Cosmin Iuga
2,352 Points

SELECT phone_book WHERE last_name =%% AND last_name IS NOT NULL;

Josh Keenan
Josh Keenan
17,734 Points

Here's my solution:

> SELECT last_name FROM phone_book WHERE last_name IS NOT NULL

It needs you to just get the last_name column when it isn't null

Cosmin Iuga
Cosmin Iuga
2,352 Points

that worked. Awesome.

Tommy Gebru
Tommy Gebru
30,147 Points

It looks like you were close Cosmin - also i believe that if you wanted to use the characters for string match %

Be sure to use the keyword LIKE for example LIKE %book%