Quantiphi interview question

Explain the joins in SQL