SELECT COUNT(*) as qty, result, extract(month from date_begin) as month, extract(year from date_begin) as year 
FROM ta_journal_log_event
GROUP BY result, extract(month from date_begin), extract(year from date_begin)

SELECT COUNT(*) as qty, result, extract(month from date_begin) as month, extract(year from date_begin) as year 
FROM ta_journal_log_event
GROUP BY result, extract(month from date_begin), extract(year from date_begin);






 WHERE (`date_begin` >= '2023-05-04 00:00:00' AND `date_end` <= '2023-05-05 00:00:00')
AND username LIKE '%ADMINISTRADOR%'  
ORDER BY `ta_journal_log_event`.`date_begin` DESC