热情的悲伤蛙求求offer

分类

/ 注册

全部文章（共25篇）

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

with a as( select course_id, in_datetime as time, 1 as diff from attend_tb union all select ...

2025-05-09

0 12

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

# 先统计每个用户的在线时长 with a as( select user_id, course_id, sum(timestampdiff(second,in_datetime,out_datetime)) as zaixian fr...

2025-05-09

0 8

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

with a as( select ct.course_name, round(avg(timestampdiff(second,at.in_datetime,at.out_datetime)/60),2) as avg_Len from ...

2025-05-09

0 10

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

with a as( select ct.course_id, ct.course_name, count(distinct at.user_id) as online_num from attend_tb as at...

2025-05-09

0 8

题解 | 牛客直播转换率

with a as( select ct.course_id, ct.course_name, round(sum(bt.if_sign)*100/sum(bt.if_vw),2) as sign_rate from ...

2025-05-09

0 8

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

# 得到连续登录的天数，rank然后用datediff INTERVAL rt days得到新的一列，再根据这一列进行聚类count就可以得到以这一天为起点的连续天数 with a as( select distinct sales_date, user_id...

2025-05-09

0 11

题解 | 某宝店铺动销率与售罄率

# 先得到每款商品的销售数目和销售总金额 with a as( select style_id, sum(inventory) as kucun, sum(tag_price*inventory) as beihuo from ...

2025-05-09

0 10

题解 | 某宝店铺的实际销售额与客单价

select sum(sales_price) as sales_total, round(sum(sales_price)/count(distinct user_id),2) as per_trans from sales_tb

2025-05-09

0 13

题解 | 某宝店铺的SPU数量

select style_id, count(item_id) as SPU_num from product_tb group by style_id order by SPU_num desc;

2025-05-09

0 10

题解 | 工作日各时段叫车量、等待接单时间和调度时间

# dayofweek()返回星期几 hour 返回时间 with a as( select case when hour(r.event_time) in (7,8) then '早高峰' when hour(r.event_time) between 9 and 16 t...

2025-05-09

0 9