Tesco interview question

Lots of questions around SQL, database and algorithms.