摸鱼头领

分类

题解(2)

/ 注册

全部文章（共2篇）

SQL大厂面试真题

SQL1 各个视频的平均完播率 select video_id,round(sum(if_over)/count(if_over),3) as rate from ( select video_id,if(diff>=duration,1,0) as if_over from ...

Mysql

2022-03-23

0 533

SQL进阶挑战

SQL14 SQL类别高难度试卷得分的截断平均值思路：去掉正序+倒序排序 top1的行即完成截断的筛选步骤： 1）exam_record表用is not null筛选出已完成的信息 2）examination_info表筛选题目要求信息（tag='SQL' and difficulty =...

Mysql

2022-03-15

0 353