Pregunta de entrevista de Eli Lilly and Company

Write sql query to achieve some goal