Acoustic Interview Question

Write complex SQL query based on a filter criterion.