题解 | #近一个月发布的视频中热度最高的top3视频#

select video_id,round((100crt+5sl+3sc+2sr)/(DATEDIFF((select max(DATE(end_time)) from tb_user_video_log),md)+1),0)hot from(select video_id,avg(if(TIMESTAMPDIFF(second,start_time,end_time)>=duration,1,0))crt, sum(if_like)sl,sum(if_retweet)sr,count(comment_id)sc,date(max(end_time))md from tb_user_video_log join tb_video_info using(video_id) group by video_id)a order by hot desc

我这放在datagrip里都可以得出正确答案，不懂为啥网站里执行不行，自测输入也是说对，无语