牛客794288350号

分类

/ 注册

全部文章（共50篇）

题解 | 电商平台想要了解不同商品在不同月份的销售趋势

select product_id, product_name, round(sum(sales),0) as total_sales, round(max(sales),0) as max_monthly_sales, round(min(sales),0)...

2025-06-17

2 23

题解 | 电商平台需要对商家的销售业绩、退款情况和客户满意度进行综合评估

select m.merchant_id, m.merchant_name, coalesce(sales.total_sales_amount,0) as total_sales_amount, coalesce(r.total_refund_amount,0) a...

2025-06-16

0 17

题解 | 对商品的销售情况进行深度分析

select product_category, age_group, total_sales_amount, round(total_sales_amount/sum(total_sales_amount) over (partition by product_ca...

2025-06-14

0 16

题解 | 完成员工考核试卷突出的非领导员工

select emp_id, emp_level, exam_tag from (select n.emp_id, n.emp_level, r.score, i.exam_id, i...

2025-06-13

0 18

题解 | 查询成绩

select count(*) from (select s.sid from SC s join Course c on s.cid=c.cid where c.cname in ('语文','数学'...

2025-06-12

0 17

题解 | 商品交易(网易校招笔试真题)

select g.id, g.name, g.weight, sum(t.count) as total from goods g join trans t on g.id=t.goods_id where g.weight<50 g...

2025-06-12

0 18

题解 | 网易云音乐推荐(网易校招笔试真题)

WITH people as ( select follower_id from follow where user_id = 1 ), likes as ...

2025-06-12

0 26

题解 | 统计用户获得积分

select user_id, sum(floor(timestampdiff(minute,visit_time,leave_time)/10)) as point from visit_tb group by user_id order by poin...

2025-06-12

0 16

题解 | 统计用户从访问到下单的转化率

WITH daily_order as ( select date (order_time) as day, count(distinct user_id) as order_head from ...

2025-06-12

0 22

题解 | 统计各等级会员用户下订单总额

select u.vip, ifnull(sum(o.order_price),0) as order_total from uservip_tb u left join order_tb o on o.user_id=u.user_id group by u...

2025-06-12

0 18