Anonymous Content interview question

Pivot table ,and sql queries