Sony interview question

Basic sql questions. No real technical challenge