SQL Server PIVOT operation which rotates a table-valued expression. It turns the unique values in one column into multiple columns in the output and performs aggregations by SUM (), COUNT (), AVG (), ...

Select * (All Columns) in the rectangle representing the table or table-valued object. The Query and View Designer automatically fills the term Count into the Group By column in the Criteria pane and ...