Hints


 * You might consider to look at the data wharehouse for the reporting assignment. The data in the DW might be easier to organize for your report**


 * Having trouble writing SQL queries. Consider using the more advanced query designer. Click the icon as pictured below



This will bring up a more advanced editor that can help you build queries. If you right click, you will be able to add table and then determine what fields you want. Try adding a few tables (especially joins that make sense, ie a id to its parent table).

**