CREATE TABLE `notifications_stat` (
  `period` date NOT NULL,
  `id_mkd` int(11) NOT NULL,
  `notif_in_mkd` int(11) NOT NULL,
  `debt_in_mkd` double NOT NULL,
  KEY `fk_ns_mkd` (`id_mkd`),
  KEY `i_per` (`period`),
  CONSTRAINT `fk_ns_mkd` FOREIGN KEY (`id_mkd`) REFERENCES `mkd` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SELECT c.id_mkd,COUNT(n.id_contragent) notif_in_mkd,SUM(debt_total) debt_in_mkd
FROM notifications n 
INNER JOIN contragents c ON n.id_contragent=c.id 
WHERE date_from BETWEEN '2019-11-01' AND '2019-11-30'
GROUP BY c.id_mkd

CREATE DEFINER=`...` EVENT `event_notification_stat`
	ON SCHEDULE
		EVERY 1 MONTH STARTS '2019-12-01 00:30:00'
	ON COMPLETION PRESERVE
	ENABLE
	COMMENT 'ежемесячный сбор статистики по выписанным уведомлениям'
	DO BEGIN
	INSERT INTO direct_contracts.notifications_stat (period,id_mkd,notif_in_mkd,debt_in_mkd)
	SELECT CURRENT_DATE - INTERVAL 1 MONTH,c.id_mkd,COUNT(n.id_contragent),SUM(debt_total)
	FROM direct_contracts.notifications n 
	INNER JOIN direct_contracts.contragents c ON n.id_contragent=c.id 
	WHERE date_from BETWEEN CURRENT_DATE - INTERVAL 1 MONTH AND CURRENT_DATE - INTERVAL 1 DAY
	GROUP BY c.id_mkd;
END