Filtering Data

SELECT Code, Name
FROM country
WHERE NOT Code in ('RUS', 'USA')


Code Name
ABW Aruba
AFG Afghanistan
AGO Angola
AIA Anguilla
ALB Albania
AND Andorra
ANT Netherlands Antilles
ARE United Arab Emirates
ARG Argentina
...

Select all countries, except for Russia and the USA.
The NOT keyword is used in a WHERE clause to negate a condition.