Sovrn interview question

Explain SQL operations. Types of JOINS, UNION, etc