Clairvoyant interview question

Difference between different SQL joins.