PTC interview question

SQL - Joins, Window functions, PIVOT Machine Learning Power BI