Pregunta de entrevista de Dunelm

SQL questions, both simple and complicated.