Sony Interview Question

Basic sql questions. No real technical challenge