Match the descriptions to these grouping and windows terms: GROUP BY, HAVING, Window function, PARTITION BY.

Grouping and windowsConcept relationships

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

A window partition defines which related rows contribute to each independent calculation.

Window calculations add analytical values without collapsing all members into a single grouped row.

Grouping lets aggregate expressions summarize each set of matching rows.

HAVING can test aggregate results such as a group's total or count.

Loading question…