牛客527342094号

分类

/ 注册

全部文章（共3篇）

题解 | 最长连续登录天数

SELECT C.user_id, MAX(num) AS max_consec_days FROM ( SELECT B.user_id, COUNT(start_date) AS num FROM ( SELECT A.user_id, ...

2025-06-19

0 6

题解 | 物流公司想要分析快递小哥的薪资构成和绩效情况

SELECT CI.courier_id, courier_name, base_salary + delivery_fee_total - expense_amount_total AS total_income FROM couriers_info AS CI JOI...

2025-06-18

0 8

题解 | 分析每个员工在不同项目中的绩效情况

SELECT E.employee_id, employee_name, performance_score AS first_half_2024_score, row_number()over(partition by project_name order...

2025-06-18

0 7