Demonstration should include using
Cartesian join
equijoin, including self-join and outer join
non-equijoin
outer join.