Highest Book's Readers in your Library (Koha SQL Reports Queries)

Highest No.of. Book's Readers Name List.

• Crete the New SQL Report
• Copy and Paste  following lines in the SQL report. Save and close.

SELECT

    cardnumber as 'Lib Card No',

    surname as Name,

    borrowernotes as Department,

   COUNT(*) as Reading

FROM

   borrowers b

   JOIN statistics s ON (b.borrowernumber = s.borrowernumber)

   WHERE DATE(datetime) between <<From|date>> and <<Until|date>>

GROUP BY b.borrowernumber

ORDER BY Reading DESC

Run Report