heyboysay

分类

未归档(1) 题解(2)

/ 注册

全部文章（共24篇）

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

with base_name as( select sa.salary_id , sa.staff_id , round(sa.normal_salary - sa.dock_salary,3) as diff_salary from ...

2025-04-21

0 69

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

select u.vip , coalesce(sum(o.order_price),0) as order_total from uservip_tb u left join order_tb o on u.user_id = o.user_id group by u.vip...

2025-04-21

0 53

题解 | 查看不同年龄段的用户明细

select device_id , gender , case when age < 20 then '20岁以下' when age between 20 and 24 then '20-24岁' when age ...

2025-04-20

0 68

题解 | 找出每个学校GPA最低的同学

with rank_table as( select device_id, university, gpa , rank() over(partition by university order by gpa) as rank...

2025-04-20

0 72