Learn The WHERE Clause Operators | Filtering Data

/

Introduction to SQL (60/40)

SQL supports a lot of conditional statements.

Less Than

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


              123
            
SELECT name, population
FROM country
WHERE population < 2424200;

Less Than or Equal to

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


              123
            
SELECT name, population
FROM country
WHERE population <= 2424200;

Not Equal

The following example retrieves all non-Asian countries:


              123
            
SELECT name, continent
FROM country
WHERE continent<>'Asia';

1. Which query returns the names of countries with a population equal to 2,424,200 using the '=' operator in the WHERE clause?

2. Which SQL query returns all countries that are not in Europe using the '<>' operator?

3. Write a SQL query to select the country name and population for all countries with a population between 5,000,000 and 50,000,000, inclusive. Use the BETWEEN operator.

Everything was clear?

Thanks for your feedback!

Section 3. Chapter 3

Ask AI

Ask AI

Ask anything or try one of the suggested questions to begin our chat

Swipe to show menu

SQL supports a lot of conditional statements.

Less Than

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


              123
            
SELECT name, population
FROM country
WHERE population < 2424200;

Less Than or Equal to

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


              123
            
SELECT name, population
FROM country
WHERE population <= 2424200;

Not Equal

The following example retrieves all non-Asian countries:


              123
            
SELECT name, continent
FROM country
WHERE continent<>'Asia';

1. Which query returns the names of countries with a population equal to 2,424,200 using the '=' operator in the WHERE clause?

2. Which SQL query returns all countries that are not in Europe using the '<>' operator?

3. Write a SQL query to select the country name and population for all countries with a population between 5,000,000 and 50,000,000, inclusive. Use the BETWEEN operator.

Everything was clear?

Thanks for your feedback!

Section 3. Chapter 3

some-alt