I am going to show you how to quickly pivot your data in with the PIVOT function. This will essentially allow you to create a Pivot Table with your SQL query and indicate the aggregation type. Also, we will set an index for our pivot table.
#sql
#dataanalysis
#datascience
#sqlinterview
Learn and Practide SQL coding online at DataCamp, check out my affiliate link:
https://datacamp.pxf.io/KjO5ba
Background Music
________________________________________________________________
Slowly by Tokyo Music Walker | / user-356546060
Music promoted by https://www.free-stock-music.com
Creative Commons / Attribution 3.0 Unported License (CC BY 3.0)
https://creativecommons.org/licenses/...