COUNT_IF
Returns the number of rows for which the expression is TRUE.
Analyze Syntax
func.count_if(get_column(table, 'salary') > 80000)
Analyze Examples
func.count_if(get_column(table, 'salary') > 80000)
┌────┐
│ 42 │
└────┘
SQL Syntax
COUNT_IF(<salary> > 80000)
SQL Examples
SELECT COUNT_IF(salary > 80000) FROM employees;
┌────┐
│ 42 │
└────┘