[Koha] SQL - Library Books Investment by Collection Code
SATISH
lis4satish at gmail.com
Fri Dec 8 19:20:56 NZDT 2017
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 AS 'Collection Code',
COUNT(DISTINCT items.biblionumber) AS 'No of Titles',
COUNT(itemnumber) AS 'No of Volumes',
SUM(price) AS 'Investment or total expenditure in Rs.'
FROM items
GROUP BY ccode
----------------------------
Output,
https://ibb.co/kyRueb
with thanks
Satish
More information about the Koha
mailing list