Citi Interview Question

Type of joins in sql