Question d’entretien chez Infosys

They have asked to write Query for a given scenario.