[Koha] tiny bit of help needed with report

[Lisa Peel]

Hello

I apologise for the simplicity of this question but could really use some help.

I want to use the Hourly report in the KOHA wiki for ‘Checkouts by Hour in Selected Date Range’ as below

SELECT YEAR(statistics.datetime) AS Year, MONTH(statistics.datetime) AS Month, DAY(statistics.datetime) AS Day, HOUR(statistics.datetime) AS Hour,
count(*) AS Checkouts
FROM statistics
WHERE statistics.datetime BETWEEN '2014-01-06 13:00:59' AND '2014-01-09 16:59:59'
AND statistics.type = 'issue'
GROUP BY Year, Month, Day, Hour

However, I also need to add branch code as well so I can determine the number of checkouts by library but I am struggling to know what extra code to add? My knowledge of SQL is very, very limited and any help would be really appreciated

Regards

Lisa

Mrs Lisa Peel
Head of Learning Resources, SEG Services
Swiss Education Group
________
Avenue des Alpes 62
CH-1820 Montreux, Switzerland
Mobile: +41 (0)79 228 0151<tel://+41(0)792280151>
Skype: biblio1897<skype://biblio1897>
www.swisseducation.com<https://www.swisseducation.com/en/>
Facebook<https://www.facebook.com/swisseducationgroup> | Instagram<https://www.instagram.com/swisseducationgroup/> | Linkedin<https://www.linkedin.com/company/seg-swiss-education-group>

[http://signature.swisseducation.com/SEG2019.jpg]<https://www.swisseducation.com/en/>

Confidentiality and Disclaimer:
This message contains confidential information and is intended only for the individual named.
Email messages are provided for informational purposes, therefore the sender does not accept
liability for any errors or omissions in the contents of this message.