Capgemini Interview Question

Different types of joins in sql