PwC Interview Question

Some medium difficulty questions from SQL