牛客134017745号

分类

/ 注册

全部文章（共28篇）

题解 | 异常的邮件概率

select date, round(avg(type = 'no_completed'), 3) as p from email where send_id not in (select id from user where is_blacklist = 1) ...

2025-04-19

0 50

题解 | 牛客每个人最近的登录日期(五)

with new_login as ( select ifnull(cnt, 0) as new_cnt, login.date from login left join ( select ...

2025-04-19

0 59

题解 | 牛客的课程订单分析(七)

with satisfied_order as ( select (case client_id when 0 then 'GroupBuy' else name end) as source, count(*) over(partition by user_...

2025-04-17

0 47

题解 | 统计每个产品的销售情况

with t1 as ( # 求出产品ID、总销售额、单价、总销量、月平均销售额 select o.product_id as product_id, sum(quantity*unit_price) as total_sales, ...

2025-04-13

0 48

题解 | 各个部门实际平均薪资和男女员工实际平均薪资

with avg_sal as ( select department, staff_gender, normal_salary-dock_salary as salary from staff_tb ...

2025-04-13

0 59

题解 | 最受欢迎的top3课程

with popular_amount as( select c.cid as cid, count(uid) as pv, sum(timestampdiff(minute, start_time, end_time)) as time_le...

2025-04-13

0 73

题解 | 输出播放量最高的视频

with peak_uv_atonetime_count as ( select p1.cid as cid, sum(if((p1.start_time between p2.start_time and p2.end_time), 1, 0)) as pe...

2025-04-13

17 92

题解 | 每个顾客购买的最新产品名称

# 子查询 select o.customer_id, customer_name, product_name as latest_order from orders o join customers c on o.customer_id = c....

2025-04-13

0 64

题解 | 商品销售总额分布

select ( case when pay_method = '' then 'error' else pay_method end ) as pay_method, count(*) as c...

2025-04-12

0 49

题解 | 商品价格排名

with price_rk as ( select product_id, rank() over(partition by type order by price desc) as rk from product_info group by type,...

2025-04-12

0 43