Please click the link for details - https://www.vskills.in/certification/tutorial/sql-server-2008/subqueries-pivoting-and-ranking-functions/
