Pregunta de entrevista de Cargill

How would you write a sql query to extract data?