Transaction by coid

SELECT
coid,
COUNT(id) AS transaction_count
FROM
erp_glitem
WHERE
created >= ‘2025-05-01’ AND created < ‘2025-06-01’
GROUP BY
coid
ORDER BY
coid;

SELECT
gl_date,
gl_ah_code,
gl_desc,
gl_sourcedr,
gl_sourcecr,
coid
FROM
erp_glitem
WHERE
created >= ‘2025-07-01’ AND created < ‘2025-08-01’ AND coid = ‘fungeasyacc’
ORDER BY
coid;