OkMaid

分类

题解(34)

/ 注册

全部文章（共70篇）

#统计2021年10月每个退货率不大于0.5的商品各项指标#

select * from ( select product_id, round(sum(if_click)/count(*), 3) ctr, round(sum(if_cart)/sum(if_click), 3)...

Mysql

2022-07-26

0 271

题解 | #计算商城中2021年每月的GMV#

select date_format(month,'%Y-%m'), sum(t1.g1) as GMV from (select event_time as month, sum(tot...

Mysql

2022-07-26

0 258

题解 | #2021年11月每天新用户的次日留存率#

select t1.first_day, round(count(t2.uid)/count(t1.uid),2) as uv_left_rate from (select uid, min(date(in_time)) ...

Mysql

2022-07-25

0 269

题解 | #2021年11月每天的人均浏览文章时长#

select date_format(in_time, '%Y-%m-%d') as dt, round(sum(timestampdiff(second,in_time,out_time))/cou...

Mysql

2022-07-14

0 255

题解 | #每个创作者每月的涨粉率及截止当前的总粉丝量#

select author, date_format(start_time, '%Y-%m') as month, round(SUM(case when if_follow=1 then 1 &n...

Mysql

2022-07-14

0 327

题解 | #平均播放进度大于60%的视频类别#

ROUND(AVG( IF(TIMESTAMPDIFF(SECOND, start_time, end_time) >&...

Mysql

2022-07-11

0 419

题解 | #各个视频的平均完播率#

select t1.video_id, round(sum(if(end_time - start_time >= duration, 1, 0))/count(t1.uid), 3) avg_comp_...

Mysql

2022-07-06

0 286

题解 | #对过长的昵称截取处理#

select uid, if(char_length(nick_name) > 13, concat(substr(nick_name, 1, 10)...

Mysql

2022-07-06

0 315

题解 | #修复串列了的记录#

SELECT exam_id, SUBSTRING_INDEX(tag, ',', 1), SUBSTRING_INDEX(SUBSTRING_INDEX(tag, ',', 2), ',', -1), ...

Mysql

2022-07-04

0 306

题解 | #0级用户高难度试卷的平均用时和平均得分#

select uid, round(sum(if(score is not null, score, 0))/count(start_time), ...

Mysql

2022-07-02

0 279