[Koha] SQL - Library Books Investment by Collection Code

Hi, As per our Library reporting requirements, I have just prepared SQL on "Library Books investments by Collection Code". I thought of sharing it, because it is useful for Engineering College Libraries in India for AICTE reports preparation. I did not find it in SQL Library and if somebody is alr

Re: [Koha] SQL - Library Books Investment by Collection Code

Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with MySQL - mysql Ver 14.14 Distrib 5.5.57, for debian-linux-gnu (i686) using readline 6.3 (from About Koha page) Library Books investments by "Collection Code" for a single library/default library. - SELECT ccode