Pregunta de entrevista de Infosys

Asked for a SQL statement that would pull specific row based on criteria