There are a couple here that may be useful, at least for your first question. Bob https://wiki.koha-community.org/wiki/SQL_Reports_Library#Library_Books_Investment_by_Collection_Code
On Mon, 9 Mar 2020 at 17:33, Yatheesh lis <yathee...@gmail.com> wrote: > Hi > > I would like to know total cost of books in my library > Can anyone suggest -SQL query on following details > 1) total number books & total cost. > 2) total number of books with out cost > > Thank you > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha