五首绝句哈

分类

/ 注册

全部文章（共32篇）

题解 | 分析不同门店各类商品的库存情况和销售情况

SELECT a.store_id,b.store_name,c.product_category,a.inventory_quantity,a.sales_amount FROM sales_inventory AS a JOIN stores AS b ON a.store_id = b.sto...

2025-06-19

0 8

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

SELECT customer_id,customer_name,product_name AS latest_order FROM( SELECT a.customer_id,b.customer_name,c.product_name,a.order_date, ROW_...

2025-06-19

0 7

题解 | 每个部门薪资排名前两名员工

SELECT department,employee_name,salary FROM( SELECT department,employee_name,salary, RANK() OVER (PARTITION BY department ORDER BY salary ...

2025-06-19

0 6

题解 | 商品价格排名

SELECT product_id, product_name, type, price FROM ( SELECT product_id, product_name, t...

2025-06-19

0 10

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

WITH t1 AS( SELECT product_id, round(sum(quantity*unit_price),2) AS total_sales, unit_price, sum(quantity) AS total_quantity, ...

2025-06-18

1 10

题解 | 统计快递运输时长

select exp_type,round(avg(duration),1) AS time FROM( SELECT a.exp_type,round(TIMESTAMPDIFF(MINUTE,b.out_time,b.in_time)/60,1) AS duration F...

2025-06-18

1 9

题解 | 统计加班员工占比

SELECT department,concat(format(avg(CASE WHEN duration > 570 THEN 1 ELSE 0 END)*100,1),'%') AS ratio FROM( SELECT a.staff_id,a.department,r...

2025-06-18

1 11

题解 | 推荐内容准确的用户平均评分

SELECT round(avg(score),2) AS avg_score from( SELECT DISTINCT a.rec_user,b.score FROM recommend_tb AS a JOIN user_action_tb AS b ...

2025-06-18

2 9

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

SELECT department, round(avg(real_salary),2) AS average_actual_salary, IFNULL(round(avg(CASE WHEN staff_gender = 'male' THEN real_salary END),2),0) AS...

2025-06-18

0 16

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

WITH t AS ( SELECT a.emp_id, b.emp_level, TIMESTAMPDIFF(SECOND, a.start_time, a.submit_time) AS durati...

2025-06-18

1 10