描述
牛客刷题详细数据表`questions_pass_record_detail`如下,请你统计每天刷题数超过5的user_id以及刷题数,返回结果字段为顺序以及名称为
date|user_id|total_pass_count
示例1
输入:
drop table if exists questions_pass_record_detail; CREATE TABLE `questions_pass_record_detail` ( `user_id` int NOT NULL, `question_type` varchar(32) NOT NULL, `device` varchar(14) NOT NULL, `pass_count` int NOT NULL, `date` date NOT NULL); INSERT INTO questions_pass_record_detail VALUES(101, 'java', 'app', 2, '2020-03-01'); INSERT INTO questions_pass_record_detail VALUES(102, 'sql', 'pc', 15,'2021-07-07'); INSERT INTO questions_pass_record_detail VALUES(102, 'python', 'pc', 9, '2021-04-09'); INSERT INTO questi