Creating the expected results is really a manual process. Look at your sample data you provided, what should the result set returned look like, what is the correct answer? You may also need to explai why if it doesn't appear intuative, ie what rules did you use to come to the answer.