newbee松

分类

题解(4)

/ 注册

全部文章（共5篇）

题解 | #文件最后用户的部分数据#

import pandas as pd data = pd.read_csv('Nowcoder.csv',sep=',') print(data.tail(5)[['Nowcoder_ID', 'Level', 'Achievement_value', 'Language']])

2024-05-09

0 120

题解 | #牛客的课程订单分析(四)#

select t.user_id, t.first_buy_date, t.num from(select , count() over(partition by user_id) as num,min(date) over(partition by user_id) as first_buy_da...

SQL 开窗函数窗口函数 sql高阶

2021-07-11

0 378

题解 | #牛客的课程订单分析(三)#

select t.id,t.user_id,t.product_name,t.status,t.client_id,t.datefrom(select , count() over(partition by user_id) as numfrom order_infowhere product_na...

SQL 窗口函数 sql高阶开窗函数

2021-07-11

2 527

题解 | #牛客的课程订单分析(三)#

select T.*from ( select * from order_info where date > '2025-10-15' and product_name in ('C++', 'Python', 'Java') and status = 'comp...

SQL 开窗函数窗口函数 sql高阶

2021-07-11

0 465

题解 | #考试分数(三)#

select a.id, a.name, a.scorefrom (select g.id,g.score,l.name, dense_rank() over(partition by l.id order by g.score desc) rk from grade g lef...

SQL 开窗函数窗口函数 sql高阶

2021-07-11

0 394