Practice with COUNT()
As you've seen, COUNT(*)
tells you how many records are in a table. However, if you want to count the number of non-missing values in a particular field, you can call COUNT()
on just that field.
Let's get some practice with COUNT()
! You can look at the data in the tables throughout these exercises by clicking on the table name in the console.
This exercise is part of the course
Intermediate SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Count the number of records in the people table
___