表的字段：

CREATE TABLE `user_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `request_id` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `event` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `coin` int(10) NOT NULL DEFAULT '0',
  `mobile` int(10) NOT NULL DEFAULT '0',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=269 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户操作日志表';

想实现按照 event 来展示数据,单位时间内 event 出现的次数，类似这种

求助这个 sql 怎么写呢？