重生之各大厂争着抢我

分类

/ 注册

全部文章（共48篇）

题解 | 精品咖啡连锁门店王牌产品及其最忠实顾客分析

select c.shop_name, c.city, temp1.top_product, temp1.product_revenue, temp2.top_customer, temp2.customer_quantity, temp2....

2026-04-19

0 10

题解 | 播客精彩片段裂变传播链统计

with recursive temp as ( select c1.share_id as root_share_id, account_name as root_account_name, c1.share_id as cur_share...

2026-03-28

1 32

题解 | 获取所有非manager员工当前的薪水情况

select dept_no, emp_no, salary from dept_emp join salaries using(emp_no) where emp_no not in (select emp_no from dept_manager);

2026-03-25

0 40

题解 | 查找在职员工自入职以来的薪水涨幅情况

with start_salary_t as( select emp_no , salary from employees e join salaries s using(emp_no) where hire_date =from_date ...

2026-03-25

0 30

题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary

with max_salary_t as( select max(salary) as max_salary from salaries ), second_salary_t as( select max(salary) as second...

2026-03-25

0 36

题解 | 全民健身季推荐网络与积分衰减计算

with recursive temp as( select m1.member_id, m1.member_name, 1 as referral_level, rr.base_reward_points from ...

2026-03-21

0 33

题解 | 微服务架构下的深层依赖链路漏洞影响面分析

with recursive temp as( select s1.service_id, s1.service_name, 1 as dependency_depth, concat('Payment_Gateway->...

2026-03-21

0 47

题解 | 近一个月发布的视频中热度最高的top3视频

with now_t as ( select date(max(end_time)) as now_date from tb_user_video_log ), numbers_t as( select l.video_id, max(dat...

2026-03-14

0 51

题解 | 宠物猫繁育族谱追溯与遗传病风险评估

with RECURSIVE temp as( select child_cat_id as descendant_id, c2.cat_name as descendant_name, 1 as generation, he...

2026-03-14

0 45

题解 | SaaS产品高价值用户活跃度分析

with user_table as( select users.user_id, users.user_name from users join user_events using(user_id) where plan_type='Pro...

2026-03-13

0 57