Pregunta de entrevista de Acoustic

Write complex SQL query based on a filter criterion.