Count Rows and Values
Part of the SQL Foundations section of Coddy's PostgreSQL journey. Lesson 11 of 22.
An aggregate combines several input rows into one result. COUNT(*) counts rows; COUNT(column) counts only rows where that column is not NULL. Both return zero for an empty input.
Input table products:
id | name | category | price | stock | active | note |
|---|---|---|---|---|---|---|
1 | Map | travel | 12 | 5 | True | NULL |
2 | Notebook | books | 8 | 0 | True | Recycled |
3 | Atlas | books | 24 | 3 | False | NULL |
4 | Mug | home | 12 | 8 | True | Blue |
5 | lamp | home | 30 | 2 | False | Clearance |
6 | Mini map | travel | 6 | 10 | True | NULL |
SELECT COUNT(*) AS products_count, COUNT(note) AS notes_count FROM products;There are six products but only three non-null notes. A note that is an empty string would still count because it is present. Without GROUP BY, the aggregate describes the whole filtered input.
COUNT(*) counts rows; COUNT(column) counts non-null values.
Challenge
MediumReturn one row named available_count counting products with stock above zero.
The input tables are shown in the test panel. Each run starts from fresh data. Return the named columns in the stated order; do not hard-code the displayed rows.
Try it yourself
-- Write your SQL here.
This lesson includes a short quiz. Start the lesson to answer it and track your progress.
All lessons in SQL Foundations
3Summarize Rows
Count Rows and ValuesTotals and AveragesGroup by CategoryFilter Groups with HAVINGCategory Restock BudgetPractice on your own: PostgreSQL playground