Pergunta de entrevista da empresa Infosys

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