Anonymous interview question

Explain a SQL query you wrote recently and how it helps in data analysis.