表的字段:
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 怎么写呢?