The COUNT() Function

COUNT() is a function that allows you to count rows in a table or count how many rows match certain criteria.

Let’s see an example:


              12
            
SELECT COUNT(name) 
FROM country;

To count the total number of rows in the table, we can use the following syntax:


              12
            
SELECT COUNT(*)
FROM country;

Here is the country table we are working with:

Task

Swipe to show code editor

Write an SQL query to retrieve the number of rows from the country table where the continent is 'Asia' with a population of over 1000000.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 5. Chapter 3

COUNT() is a function that allows you to count rows in a table or count how many rows match certain criteria.

Let’s see an example:


              12
            
SELECT COUNT(name) 
FROM country;

To count the total number of rows in the table, we can use the following syntax:


              12
            
SELECT COUNT(*)
FROM country;

Here is the country table we are working with:

Task

Swipe to show code editor

Write an SQL query to retrieve the number of rows from the country table where the continent is 'Asia' with a population of over 1000000.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 5. Chapter 3

Switch to desktop for real-world practiceContinue from where you are using one of the options below