aggregate the result and transform into columns in sql

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

 5,880 total views,  2 views today