create / edit sql code for model ad-hoc mod report plugin

I installed moodle 2.5.6 ad-hoc sql custom report builder, i found a already made sql code I just need to add some info to to the report and limit either by active classes or by current yr what I need done: 1) need date of test taken (scorm test ) 2) need one that shows all - like current but need the test date added and one that list just current yr or only active course that are not hidden 3)add date last access course should be an easy quick project i can provide a sql dump as it is a production site