PwC interview question

Lets know about joins in sql.