Dunelm interview question

SQL questions, both simple and complicated.