Dunn Solutions interview question

how to construct a SQL query