PwC Interview Question

sql quires and joins ,