PwC interview question

1) Join Query and Basic Sql