Quantiphi Interview Question

Explain the joins in SQL