Task: Implement a FULL OUTER JOIN in SQLite

Task: Implement a FULL OUTER JOIN in SQLite: a task in Terminal-Lego-15k (Harbor dataset). SQLite does not natively support FULL OUTER JOIN . Your task is to simulate a FULL OUTER JOIN between two tables using only the join types SQLite supports (INNER JOIN and LEFT JOIN), combined with other SQL…

The task

SQLite does not natively support `FULL OUTER JOIN`. Your task is to simulate a FULL OUTER JOIN between two tables using only the join types SQLite supports (INNER JOIN and LEFT JOIN), combined with other SQL features like `UNION ALL`.

Part of PrimeIntellect/Terminal-Lego-15k.