DESCRIPTION

The function name is case-sensitive and contains upper-case ‘C’ and ‘I’. This function exists for static (table-based) aggregation only.

Returns the number of rows that match the specified criteria in the query predicate pred.