Koha How-To

What did your patrons save in 2019?

This SQL report will allow you to see what your patrons saved by borrowing items from the library rather than purchasing!

SELECT SUM( price ), SUM(replacementprice)

FROM items

WHERE YEAR(datelastborrowed)=2019;

As always, if you need help adjusting the report, just let us know by submitting a ticket! Happy Holidays!

Read more by Jessie Zairo

Tags savings, cost savings