Assertion: pivot | /r/CapableOf | perform aggregation
Facets:
Source sentences:
text: PIVOT rotates a table-valued expression by turning the unique values from one column into multiple columns in output, and performs aggregations where they are required on any remaining column values that are needed in the output.