1. What is a syntactic requirement when writing a SELF JOIN?
- You must use two different tables.
- You must assign distinct table alias names to the same table referenced in the query.
- Self joins must be FULL OUTER joins.
- You cannot use WHERE filters.
Hint: To join a table to itself, you must refer to it twice in the FROM clause, assigning distinct aliases (e.g. 'FROM employees e JOIN employees m') to resolve references.