描述
现有牛客刷题表`questions_pass_record`,请查询每天刷题通过数最多的前二名用户id和刷题数,输出按照日期升序排序,查询返回结果名称和顺序为
date|user_id|pass_count
示例1
输入:
drop table if exists questions_pass_record; CREATE TABLE `questions_pass_record` ( `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 VALUES(101, 'java', 'app', 2, '2020-03-01'); INSERT INTO questions_pass_record VALUES(102, 'sql', 'pc', 15,'2020-03-01'); INSERT INTO questions_pass_record VALUES(102, 'python', 'pc', 9, '2021-04-09'); INSERT INTO questions_pass_record VALUES(202, 'pyth