DXC Technology Interview Question

Advance SQL question, SparkSQL, basic python.