xwha

分类

/ 注册

全部文章（共2篇）

题解 | 统计各个部门平均薪资

select department, round(sum(normal_salary-dock_salary)/count(*),3) as avg_salary from staff_tb join salary_tb using(staff_id) where normal_s...

2025-02-18

2 138

题解 | 更新用户积分信息？

select user_id,sum_order_price+point as point from( select user_id,sum(order_price) as sum_order_price from order_tb where order_price>...

2025-02-12

0 98