Salesforce Interview Question

SQL question for what's the different between the joins