好奇的黑眼圈想当offer收割机

分类

/ 注册

全部文章（共10篇）

题解 | 查询出不同类别商品中，销售金额排名前三且利润率超过 20%的商品信息

( select p.product_id, product_name, category_id, sales_amount, round((sales_amoun...

2025-07-01

0 12

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

select p.product_id, product_name, sum(quantity) as total_sales, max(quantity) as max_monthly_sales, min(quantity) as min_monthly_...

2025-07-01

0 9

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

select a.merchant_id, m.merchant_name, total_sales_amount, total_refund_amount, average_satisfaction_score from ( sele...

2025-07-01

0 8

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

with total as ( select category, sum(price * quantity) as total_price from products p ...

2025-07-01

0 9

题解 | 最受欢迎的top3课程

( select p.cid, round(timestampdiff(minute, start_time, end_time), 3) as duration, score from ...

2025-06-27

0 14

题解 | 更新员工信息表

with temp as ( select employee_id, max(update_dt) as update_dt from EMPLOYEE_UPDATE gr...

2025-06-27

0 12

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

with total as ( select department, round(avg(normal_salary - dock_salary), 2) as average_actual_salary fro...

2025-06-26

0 13

题解 | 商品销售总额分布

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

2025-06-25

0 14

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

with temp as ( select exam_id, round( avg( timestampdiff(second, start_time, s...

2025-06-24

0 13

题解 | 查询成绩

select count(*) from (select sid from SC group by sid having avg(score) >60) a 只要用一张表就能过，又不需要其他信息，所以加了也没用

2025-06-24

0 10