Thanks Lynn and Bru for pointing me the direction. Here is my script to create tables and sample data, can you please guide me to get expected results?

--===== If the...

Can you please explain in details. I am having similar issue but can't find the solution.