Outstanding! Since you're doing so well, you should be ready for another operator. Check out this example:
WHERE Country.Area > ALL (
As you can see, we've got a new operator,
ALL, on the right side of the logical operator
>. In this case, '
> ALL' means 'greater than every value in the parentheses.'
As a result, we'll get all countries that are bigger (in terms of area) than all cities in our database. Liechtenstein, for instance, is a very small country. It is bigger than some cities (like Lyon, for example), but it is not bigger than every city (Berlin is bigger, for example), so it won't be shown in the result.
You can also use
ALL with other logical operators:
<= ALL, or