Tendernessnick

分类

/ 注册

全部文章（共114篇）

题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息

with t1 as( select dept_no, emp_no as manager_no, salary as manager_salary from dept_manager as dm left join s...

2025-11-06

0 14

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

with t1 as( select dept_emp.dept_no as dept_no, dept_emp.emp_no as emp_no from dept_emp left join dept_manager using(e...

2025-11-06

0 35

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

# 员工自入职以来的薪水涨幅情况 with t1 as( select emp_no, salary as max_salary from salaries where to_date='9999-01-01' ...

2025-11-06

0 16

题解 | 各用户等级的不同得分表现占比

with t1 as( select level, (case when score>=90 then '优' when score>=75 then '良' when sco...

2025-11-04

0 17

题解 | 筛选昵称规则和试卷规则的作答记录

# 特定昵称特定试卷要已经完成求平均分 with t1 as( select uid, ei.exam_id, round(avg(score),0) as avg_score from user_info as ...

2025-11-04

0 18

题解 | 筛选限定昵称成就值活跃日期的用户

with t1 as ( select uid, nick_name, achievement from user_info inner join exam_record using(ui...

2025-11-04

0 19

题解 | 每份试卷每月作答数和截止当月的作答总数。

# 每份试卷每月的作答数和累计总作答数 select exam_id, date_format(start_time,'%Y%m') as start_month, count(start_time) as month_cnt, sum(count(start_t...

2025-11-04

0 14

题解 | 对试卷得分做min-max归一化

# 高难度试卷 with t1 as( select uid, exam_id, score, min(score)over(partition by exam_id) as min_score, max(sco...

2025-11-04

0 18

题解 | 试卷完成数同比2020年的增长率及排名变化

比较笨的办法 with t1 as( select tag, submit_time from examination_info as ei inner join exam_record as er us...

2025-11-04

0 21

题解 | 未完成率top50%用户近三个月答卷情况

用最笨的方法写了个答案= = # SQL试卷未完成率>50 6和7级用户近三个月每个月答卷数目和完成数目 with t1 as( select ui.uid, (count(er.start_time)-count(er.submit_time)) as incom...

2025-11-04

0 23