EY Interview Question

Explain joins in SQL