[Koha] Collection analysis according to subject

[Mary W. Maina]

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.