Concentrix interview question

SQL 1. PIVOT/UNPIVOT 2. Window functions