Deviopath › PostgreSQL

Graded vs All Students

Easy · Aggregation

COUNT(*) counts rows. It is an aggregate function: it turns many rows into one result row. COUNT(column) is different: it counts only the rows where that column is not NULL.

Return one row with two columns: students (the number of students) and graded (the number of students who have a score).

Next: Revenue from Paid Orders