Infosys interview question

A nested SQL Query was asked