题解 | #平均播放进度大于60%的视频类别#
平均播放进度大于60%的视频类别
https://www.nowcoder.com/practice/c60242566ad94bc29959de0cdc6d95ef
select tag,concat(avg_play_progress,"%") AS avg_play_progress FROM ( select tag, round(avg(if(TIMESTAMPDIFF(SECOND, start_time, end_time)>b.duration,1,TIMESTAMPDIFF(SECOND, start_time, end_time)/b.duration))*100,2) AS avg_play_progress FROM tb_user_video_log AS a LEFT JOIN tb_video_info AS b ON a.video_id = b.video_id group by b.tag having avg_play_progress > 60 order by avg_play_progress desc ) AS abc
分享一道面试题：
function getMyWechatCode() {
const firstName = 'Jeriah';
const lastName = 'Lee';
console.info(`My WC_code is ${firstName}-${lastName}`); // you can contact me.
}