Match the descriptions to these aggregate functions terms: COUNT, SUM, AVG, MIN.

Aggregate functionsConcept relationships

Choose a match for every item. Use each answer once.

SUM computes a total over the qualifying values in a group.

COUNT(*) counts rows, while COUNT(expression) counts rows where the expression is not null.

MIN selects the lowest value rather than the first row encountered.

AVG ignores null input values rather than treating them as numeric zero.

Loading question…