MariaDB COUNT() aggregate function is used to return the count of an expression.

Syntax:

SELECT COUNT(aggregate_expression)

FROM tables

[WHERE conditions];