Tesco interview question

Please write a SQL statement to identify...