__hello__world

分类

/ 注册

全部文章（共24篇）

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

with t1 as ( select user_id, sum(if (order_price > 100, order_price, 0)) as point from order_tb ...

2025-02-28

0 51

题解 | 统计用户获得积分

select t1.user_id, sum(t1.point) point from ( select user_id, # 向下取整 floor( ti...

2025-02-28

0 51

题解 | 统计员工薪资扣除比例

select staff_id, staff_name, concat(round((dock_salary) / (normal_salary) * 100, 1), '%') as dock_ratio from staff_tb st join s...

2025-02-28

0 66

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

select t1.vip, #把null替换为0 if(t1.order_total is null, 0, t1.order_total) as order_total from (select vip, sum(order_price) order...

2025-02-27

0 91