人生最曼妙的风景，竟是内心的淡定与从容！
I found the answer myself. Reference herehttp://blog.csdn.net/swweb/ar...
The core statement is modified as follows:
SELECT `task_id`, MAX(`send_time`) AS `day` FROM `game_work` GROUP BY `task_id` ORDER BY `day` DESC
select sum(num) as num, task_id, day from tablename group by day task_id order by day desc limit 1,30
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
I found the answer myself. Reference here
http://blog.csdn.net/swweb/ar...
The core statement is modified as follows:
select sum(num) as num, task_id, day from tablename group by day task_id order by day desc limit 1,30