Create us a sandbox. A couple (perhaps 2 to 4) of tables, some sample data for the tables (not a lot, just enough to cover the problem domain), and what you want to see happening depending on what happens with queries.

You need to provide this a DDL for the tables, series of INSERT INTO statements for the sample data, possible the same for the expected results.