Cloudera interview question

Describe the type of SQL joins.