ARS T&TT interview question

Excel Pivot and basic sql queries