牛客794288350号

分类

/ 注册

全部文章（共53篇）

题解 | 贷款情况

with all_customer as ( select customer_id, sum(loan_amount) as loan_amount from loan_applications group by customer_id ), loan_amount as ( sel...

2025-10-13

0 22

题解 | 统计借阅量

select t1.book_id, t1.book_title, sum( if(DATE_FORMAT(t3.borrow_date, '%Y-%m') = '2023-02', 1, 0) ) as feb_202...

2025-10-13

0 29

题解 | 平均播放进度大于60%的视频类别

with tag_avg as (select v.tag, round(avg( case when timestampdiff(second,start_time,end_time)<=v.duration then timestampdiff(second...

2025-09-15

0 17

题解 | 牛客网用户练习的平均次日留存率

import pandas as pd from datetime import timedelta nowcoder = pd.read_csv("nowcoder.csv") # 总数 total_id = nowcoder["user_id"].cou...

2025-06-24

0 55

题解 | 查询出每个品牌在不同月份的总销售额以及购买该品牌商品的用户的平均年龄

select o.category_id, round(sum(o.order_amount),2) as total_sales, count(case when c.customer_gender='男' then 1 else null end) as male_cus...

2025-06-24

0 68

题解 | 统计牛客网用户的名字长度

import pandas as pd df=pd.read_csv('Nowcoder.csv') print(df['Name'].str.len())

2025-06-24

0 30

题解 | 牛客用户刷题量的方差与提交次数的标准差

import pandas as pd df=pd.read_csv('Nowcoder.csv') A=df['Num_of_exercise'].var() print("%.2f"%A) B=df['Number_of_submissions'].std() print...

2025-06-24

1 56

题解 | 用分位数分析牛客网用户活动

import pandas as pd df=pd.read_csv('Nowcoder.csv') print(df[['Achievement_value', 'Continuous_check_in_days']].quantile(0.25)) print(df[['Num_of_ex...

2025-06-24

0 35

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

select e.employee_id, e.employee_name, coalesce(pe.performance_score,0) as first_half_2024_score, row_number() over (partition by pr.p...

2025-06-23

0 64

题解 | 分析每个商品在不同时间段的销售情况

select product_id, product_name, q2_2024_sales_total, row_number() over (partition by category order by q2_2024_sales_total desc,produ...

2025-06-23

0 66