SELECT MONTHNAME(a.datetime) AS Month, DAY(a.datetime) AS Day, YEAR(a.datetime) AS Year, COUNT(DISTINCT(borrowernumber)) AS 'Unique patrons'
FROM statistics a
WHERE (a.datetime BETWEEN <<Between|date>> AND <<and|date>>)
    AND a.type = 'issue'
    AND branch = <<Choose Library|branches>>
GROUP BY Day, Month, Year
ORDER BY Year, MONTH(a.datetime), Day