Re: [Koha] SQL Help - Daily (on Monthly basis) & Monthly (on Yearly basis) Transactions Counts (Circulation)

On Mon, Mar 6, 2017 at 8:25 AM, Mark Alexander <marka@pobox.com> wrote:

Pretty close! Just some misplaced parens:

SELECT monthname(datetime), SUM( IF(type = 'issue', 1, 0 )) as issues, SUM( IF(type = 'renew', 1, 0 )) as renewals, SUM( IF(type = 'return', 1, 0 )) as returns

Thanks Mark! I've definitely done worse on a first draft ;-)