count()

Returns the number of rows that match a specified condition in a column.

count() follows this syntax.

SELECT count(COLUMN_NAME)
FROM DATASET
WHERE CONDITION;