Horizon Media Interview Question

Explain the difference between the SQL joins