Made changes to make it conform to business rules
Had to add data to demonstrate business rules, there is a new bug I will fix tomorrow.
the straight sql for our tests