Describe the difference between an INNER JOIN, a RIGHT JOIN, and a LEFT JOIN. Provide a business example where you would want to use each type of join.
Describe the difference between the SQL commands UNION and UNION ALL. Provide a business example where you might want to use each one.