Try this problem in the playground
The sample tables will be auto-loaded — write a query and run it instantly.
JOIN types — INNER, LEFT, RIGHT, FULL OUTER
Two tables: Orders and Customers. Demonstrate each JOIN type. Note: sql.js does not support RIGHT JOIN or FULL OUTER JOIN directly — use UNION simulations.
Setup & sample data
The playground will create these tables and populate them automatically when you click "Open Playground" above:
Solutions
Multiple approaches — try each and understand the trade-offs.