Mulai sekarangMulai gratis

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.

Latihan ini merupakan bagian dari kursus

Intermediate SQL

Lihat Kursus

Latihan interaktif langsung praktik

Cobalah latihan ini dengan melengkapi kode contoh ini.

-- Count the number of records in the people table
___
Edit dan Jalankan Kode