SQL Pivoting example

SQL PIVOT allow  us to  aggregate the results and rotate rows into columns  so in sort, we can say using PIVOT