Infosys Interview Question

A nested SQL Query was asked