LinkedIn Interview Question

1 simple sql question, but 1 very difficult case study question.