Acoustic interview question

Write complex SQL query based on a filter criterion.