What did your patrons save in 2019?

by Jessie Zairo on Dec 19, 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!