在笔试的杰克很勤劳

分类

/ 注册

全部文章（共36篇）

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

with cb2 as (with cb1 as (select tag,sta_y,count(sub_y) wc from (select tag,date_format(submit_time,'%Y') sub_y,date_format(start_time,'%Y') sta_y fro...

2023-12-02

1 252

题解 | #未完成率较高的50%用户近三个月答卷情况#

with zb as (select er.uid,tag,level,date_format(start_time,'%Y%m') start_month,submit_time,dense_rank() over (partition by uid order by date_format(st...

2023-12-01

1 200

题解 | #连续两次作答试卷的最大时间窗#

with zb as (with e3 as (select uid,start_time,px,s_sum,datediff(t_a,t_i) + 1 as max_day from (select *,count(uid) over(partition by uid) s_sum,max(s...

2023-12-01

1 205

题解 | #筛选某店铺最有价值用户中消费最多前5名#

import pandas as pd df1 = pd.read_csv('sales.csv',sep=',') df1['R_Quartile'] = pd.qcut(df1['recency'],[0,0.25,0.5,0.75,1],[4,3,2,1]).astype('str') df1...

2023-11-30

1 256

题解 |

select s1.yg as emp_no,s2.emp_no manager_no,s1.salary emp_salary,s2.salary manager_salary from (select s.emp_no as yg,salary,de.dept_no,dm.emp_no as j...

2023-11-29

1 204

题解 | #对所有员工的薪水按照排名#

select emp_no,salary,dense_ranK() over (order by salary desc) as t_rank from salaries where to_date = '9999-01-01' order by t_rank,emp_no;

2023-11-28

1 202

题解 | #统计运动会项目报名人数#

import pandas as pd df1 = pd.read_csv('items.csv',sep=',') df2 = pd.read_csv('signup.csv',sep=',') df3 = pd.merge(left=df1,right=df2,how='right',on='i...

2023-11-28

0 214

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

select e.emp_no,(ss.salary-s.salary) as growth from employees e left join salaries s on e.emp_no = s.emp_no left join salaries ss on s.emp_no = ss.emp...

2023-11-28

0 184

题解 | #获取每个部门中当前员工薪水最高的相关信息#

select d.dept_no, s.emp_no, salary as maxsalary from dept_emp d, salaries s where d.emp_no = s.emp_no and d.to_date = '999...

2023-11-27

0 234

题解 | #牛客网答题正误总数#

import pandas as pd import datetime df1 = pd.read_csv('nowcoder.csv',sep=',') df1['date'] = pd.to_datetime(df1['date']).dt.date print(df1.groupby('res...

2023-11-26

0 241