offers moderated more than once

sql

SELECT
    COUNT(count) nb_remoderation,
    month
FROM
(
    SELECT count(1) count,
           DATE_FORMAT(logged_at, '%Y-%m') month
    FROM office_offer oo
             INNER JOIN office_offer_log log ON log.object_id = oo.id
    WHERE JSON_CONTAINS(log.data, '"moderation"', '$.state')
    GROUP BY DATE_FORMAT(logged_at, '%Y-%m'), oo.id
    HAVING Count(1) > 1
) sub
-- WHERE sub.month ="2018-01"
GROUP BY month;

SELECT
    COUNT(count) nb_remoderation,
    month
FROM
(
    SELECT count(1) count,
           DATE_FORMAT(logged_at, '%Y-%m') month
    FROM room_offer ro
             INNER JOIN office_offer_log log ON log.object_id = ro.id
    WHERE JSON_CONTAINS(log.data, '"moderation"', '$.state')
    GROUP BY DATE_FORMAT(logged_at, '%Y-%m'), ro.id
    HAVING Count(1) > 1
) sub
-- WHERE sub.month ="2018-01"
GROUP BY month