EY Interview Question

Tell me about JOINS in SQL.