OkMaid

分类

题解(34)

/ 注册

全部文章（共70篇）

题解 | #某乎问答高质量的回答中用户属于各级别的数量#

select (case when author_level >= 5 and author_level <= 6 then '5-6级' &...

Mysql

2022-09-15

0 295

题解 | #某乎问答11月份日人均回答量#

select answer_date, round(count(issue_id)/count(distinct author_id), 2) as per_num from answer_tb where month(...

Mysql

2022-09-15

1 339

题解 | #牛客直播开始时各直播间在线人数#

select t1.course_id, course_name, count(distinct user_id) 'online_num' from attend_tb t1 left join course...

Mysql

2022-09-11

0 420

题解 | #牛客直播转换率#

select t1.course_id, course_name, round(sum(if_sign)*100/sum(if_vw),2) 'sign_rate' from behavior_tb t1 ...

Mysql

2022-09-11

0 275

题解 | #某宝店铺折扣率#

select round(sum(sales_price)/ sum(tag_price * sales_num) * 100, 2)as 'discount_rate(%)' from product_tb&...

Mysql

2022-08-16

0 315

题解 | #国庆期间近7日日均取消订单量#

select * from( select dt, round(sum(finish_num)over(order by dt rows 6 pr...

Mysql

2022-08-10

0 302

题解 | #有取消订单记录的司机平均评分#

SELECT COALESCE(driver_id,'总体') , round(sum(grade) / count(grade),1) from &...

Mysql

2022-08-05

0 259

题解 | #每篇文章同一时刻最大在看人数#

SELECT artical_id, MAX(uv_cnt) max_uv from (select artical_id,in_out, SUM(num)OVER(PARTITION BY artical_id&nbs...

Mysql

2022-08-02

0 274

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

select date_format(in_time, '%Y-%m-%d') as dt, round(sum(timestampdiff(second,&nbs...

Mysql

2022-08-02

0 250

题解 | #零食类商品中复购率top3高的商品#

SELECT product_id, ROUND(SUM(if(t1.repurchase > 1, 1, 0)) / COUNT(repurchase), 3)&n...

Mysql

2022-08-02

0 240