HGS Interview Question

Advance excel and pivot. sql queries