[Koha] Collection analysis according to subject

Hi good People, Am looking for an sql report that can help me analyse my collection according to specific subjects offered in specific programmes in the university.The report should be able to give me bibs and items attached to each bib. Went through the KOHA wiki reports couldn't find what i needed. Anyone out there with this solution?i would really appreciate. Kind Regards, Mary Maina.