SQL Query Search for last name

It says I'm missing a IS Keyword but if I add IS to the code then it just says something is wrong with the SQL statement. Can anyone tell me what I am missing here? Am I even approaching it the correct way?

https://teamtreehouse.com/library/sql-basics/finding-the-data-you-want/filtering-out-or-finding-missing-information-2

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.

Type in your command below.

Bummer! You're missing an IS keyword!

SELECT last_name FROM phone_book WHERE last_name LIKE "%";

last_name Holligan Kozup Chalkley McFarland Luna