1. Learn
    2. /
  2. Courses
    3. /
  3. Intermediate SQL

Exercise

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.

Instructions 1/3

undefined XP
  • 1
    • Count the total number of records in the people table, aliasing the result as count_records.
  • 2
    • Count the number of records with a birthdate in the people table, aliasing the result as count_birthdate.
  • 3
    • Count the records for languages and countries in the films table; alias as count_languages and count_countries.