Pregunta de entrevista de TCS

Different Sql scenario based question.