Example of pivot in SQL

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