牛客794288350号

分类

/ 注册

全部文章（共53篇）

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

select sf.department, round(avg(sy.normal_salary - sy.dock_salary), 2) as average_actual_salary, ifnull(round(avg(if(sf.staff_gender='mal...

2025-06-22

2 40

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

with year as ( select p.product_id, sum(p.unit_price * o.quantity) as total_sales, sum(o.quantity) as total_quantity ...

2025-06-22

0 35

题解 | 下单最多的商品

select product_id, count(*) as cnt from user_client_log where step='order' group by product_id order by cnt desc limit 1 注意审题！是下单量最多！

2025-06-21

0 41

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

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

5 47

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

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 46

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

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 42

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

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 44

题解 | 查询成绩

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 50

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

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 38

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

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

2025-06-12

0 59