牛客207221769号

分类

题解(2)

/ 注册

全部文章（共57篇）

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

select answer_date,round(count(1)/count(distinct author_id),2) per_num from answer_tb group by answer_date

2024-02-01

0 202

题解 | #牛客直播各科目同时在线人数#

select course_id,course_name,max(curnum) max_num from( select course_id,sum(diff) over(partition by course_id order by dt,diff desc) curnum fr...

2024-02-01

0 206

题解 | #牛客直播各科目出勤率#

with t1 as( select user_id, course_id, if_sign, round(sum(timestampdiff(second,in_datetime,out_datetime))/60,1...

2024-02-01

0 214

题解 | #牛客直播各科目平均观看时长#

select course_name,round(sum(timestampdiff(second,in_datetime,out_datetime))/60/count(1),2) avg_Len from course_tb join attend_tb using(course_id) gro...

2024-02-01

0 161

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

select course_id,course_name,round(sum(if_sign)/sum(if_vw)*100,2) "sign_rate(%)" from course_tb join behavior_tb using(course_id) group by c...

2024-02-01

0 175

题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#

with t1 as( select DISTINCT user_id, sales_date, dense_rank() over(partition by user_id order by sales_date) rk from sales_tb ) selec...

2024-02-01

0 166

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

select round(sum(sales_price)/sum(tag_price*sales_num)*100,2) "discount_rate(%)" from product_tb left join sales_tb using(item_id) 折扣率=GMV/（...

2024-02-01

0 240

题解 | #每个城市中评分最高的司机信息#

select city,driver_id,avg_grade,avg_order_num,avg_mileage from ( select city, driver_id, round(avg(grade),1) avg_grade, max(round(...

2024-01-31

0 254

题解 | #2021年国庆在北京接单3次及以上的司机#

select "北京" city, round(AVG(driver_order),3) avg_order_num, round(AVG(money),3) avg_income from( select city,count(order_id...

2024-01-31

0 223

题解 | #统计2021年10月每个退货率不大于0.5

select product_id, round(sum(if_click)/count(1),3) ctr, round(sum(if_cart)/sum(if_click),3) cart_rate, round(sum(if_payment)/s...

2024-01-30

0 188