Tesco interview question

Write a SQL statement to solve a problem (query problem)