CAN SOMEONE HELP ME WIT HMY CODE

Question

You are given the following suppliers table :

Write a query to output the information about all suppliers who are not in London or Paris.

Combine the WHERE statement and the NOT IN operator. Also, don't forget to use parentheses.

select * from suppliers
where city NOT IN ('london' or 'Paris');

Answer 1

NOT IN ( 'London', 'Paris' );

Separate them by comma.

Answer 2

select * from suppliers
where city not in('London','Paris')
and status is not Null
order by name ASC;

Answer 3

All seems good

Answer 4

yea but solo learn keeps telling me that its wrong for what ever reason

Answer 5

Case sensitive "London"

Answer 6

SELECT*FROM SUPPLIERS
WHERE CITY NOT IN('London','Paris');

Answer 7

SELECT*FROM SUPPLIERS
WHERE CITY NOT IN('London','Paris')
and status is not NULL;

Answer 8

Please answer