Deleting names

If you're looking to delete a single contact with first_name of "Jonathan" and last_name of "Luna" then your query should be:

DELETE FROM phone_book WHERE first_name = "Jonathan" AND last_name = "Luna";

If you're trying to delete ALL Jonathan's and ALL Luna's from the phone book, your query should be:

DELETE FROM phone_book WHERE first_name = "Jonathan" OR last_name = "Luna";

Following all the other queries wouldn't achieve what you're trying to accomplish.

Thomas is correct that

DELETE FROM phone_book WHERE first_name in ("Jonathan", "Luna");

is the same as

DELETE FROM phone_book WHERE first_name = "Jonathan" OR  first_name = "Luna";

But what that query will do is delete every contact with the first name of Jonathan, and the first name of Luna.

Hope this clears things up a bit.

try

DELETE FROM phone_book WHERE first_name in ("Jonathan", "Luna");

this is the answer...

DELETE FROM phone_book WHERE first_name = "Jonathan" AND last_name = "Luna";

DELETE FROM phone_book WHERE first_name LIKE "Jonathan%" AND last_name LIKE "%Luna";

It says delete all contacts with first name Jonathan and last name Luna, i believe we are suppose to delete all instances of the names so below is the correct answer. DELETE FROM phone_book WHERE first_name LIKE "Jonathan%" AND last_name LIKE "%Luna";

You only giving a value for the first name. here is a template for your solution, remember you have two conditions

DELETE FROM <table> WHERE <condition> AND <condition>

The table is phone_book while the conditions are the first_name = "Jonathan" and the last_name = "Luna"

DELETE FROM phone_book WHERE first_name = "Jonathan" AND last_name = "Luna"

I would separate your conditons & repeat the AND:

DELETE FROM phone_book WHERE first_name = "Jonathan" AND first_name = "Luna";

If that doesnt work try the EQUALS keyword.

Then cant you use the OR instead of AND? You are right abou the AND....