SQL PIVOT & UNPIVOT simple explanation 

Thank you so much! You explained better than every instructor and course paper I found on the internet and offline as well! You're a hero.

Thank you so much for explaining this topic so well.

its good ,can you please add two more columns like profit and lose and make a pivot with all columns avaliable in the table .i want one column with count ,other with max and another with sum .can you please do it ,i have such requirements.

I have to do dynamically. How can i do

madam in from clause we have to write select * is complusory or we can write column names

why do we have to put [2019] , and not just 2019?

Your voice is not at all clear