What does the SQL PIVOT operation do?

A Rotates rows into columns, transforming distinct values from one column into multiple columns with aggregated values B Rotates columns into rows, normalizing wide tables into a long format C Transposes the entire table so rows become columns and columns become rows D Sorts the result set along two dimensions simultaneously