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.