///extract another list containing the names of employees that do not contain "Jack"./// I believe for answering this question, both first_name & last_name shoud be taken into query as there is no specification given in the question. query should read as below: SELECT * FROM employees WHERE first_name NOT LIKE ('%Jack%') OR last_name NOT LIKE ('%JACK%'); - please confirm. you have taken only first_name in your workings. SELECT * FROM employees WHERE first_name NOT LIKE ('%Jack%'); Thanks in Advance.

i don't think you should use OR in this situation but rather use the AND operator

Follow this topic

Last answered:

08 Jan 2023

Posted on:

05 Dec 2021

Query in WILDCARD CHARACTERS assignment

1 answers ( 0 marked as helpful)

Posted on:

08 Jan 2023