offers nb moderation by month

gistfile1.txt

SELECT
COUNT(count),
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 oo.id, month
) sub
GROUP BY month;

SELECT
COUNT(count),
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 ro.id, month
) sub
GROUP BY month