PwC interview question

sql quires and joins ,