Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
The WHERE Clause Operators | Filtering Data
Introduction to SQL

The WHERE Clause Operators

SQL supports a lot of conditional statements.

Operator Equality
= Equality
<> Inequality
< Less than
<= Less than or equal to
> Greater than
>= Greater than or equal to
BETWEEN Between two specified values
IS NULL Is a NULL value

Let’s look at the examples:
This example lists all countries that have a population of less than 2424200:

The following example retrieves all countries with a population less than or equal to 2424200:

The following example retrieves all non-Asian countries:

Task

Write an SQL query to retrieve the name, population, region, and capital columns from the country table (please retrieve these columns in this order), returning only the countries with a region named Southern Europe.

Note

Please note that Southern Europe should be correctly capitalized, and southern europe should not be the same. So, be careful and write it as Southern Europe.

Here's a short example of the country table:

idnamecontinentregionsurfaceareacapitalpopulation
1JapanAsiaEastern Asia377829Tokyo126714000
2LatviaEuropeNULL64589Riga2424200
3MexicoNorth AmericaCentral America1958201Mexico City98881000
.....................
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 3. Chapter 3
toggle bottom row
course content

Course Content

Introduction to SQL

The WHERE Clause Operators

SQL supports a lot of conditional statements.

Operator Equality
= Equality
<> Inequality
< Less than
<= Less than or equal to
> Greater than
>= Greater than or equal to
BETWEEN Between two specified values
IS NULL Is a NULL value

Let’s look at the examples:
This example lists all countries that have a population of less than 2424200:

The following example retrieves all countries with a population less than or equal to 2424200:

The following example retrieves all non-Asian countries:

Task

Write an SQL query to retrieve the name, population, region, and capital columns from the country table (please retrieve these columns in this order), returning only the countries with a region named Southern Europe.

Note

Please note that Southern Europe should be correctly capitalized, and southern europe should not be the same. So, be careful and write it as Southern Europe.

Here's a short example of the country table:

idnamecontinentregionsurfaceareacapitalpopulation
1JapanAsiaEastern Asia377829Tokyo126714000
2LatviaEuropeNULL64589Riga2424200
3MexicoNorth AmericaCentral America1958201Mexico City98881000
.....................
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 3. Chapter 3
toggle bottom row
some-alt