MIN
and MAX
return the smallest and largest values of a column, respectively.
The field being min/maxed, in this case
rating
, must be indexed as
fast.MIN
/MAX
ignore null values. Use COALESCE
to include them in the final sum:
MIN
was pushed down, look for a ParadeDB Aggregate Scan
with min
/max
in the EXPLAIN
output:
Expected Response