Brickwork Ratings interview question

Pivot table, Lookup , Sort using formula