Horizontal AggregationΒΆ coalesce Returns the first non-null value among the given. count Returns the number of rows of the current table, like COUNT(*) in SQL. all any max The maximum of the given columns. min The minimum of the given columns. sum