Demonstration should include using
CROSS JOIN
NATURAL JOIN
JOIN ... USING
JOIN ... ON
RIGHT OUTER JOIN
LEFT OUTER JOIN
FULL OUTER JOIN
self-join
non-equijoin.