Simon-Kucher interview question

SQL questions on online assessment.