Owen433

分类

/ 注册

全部文章（共65篇）

题解 | #删除记录（一）#

delete from exam_record where timestampdiff(minute,start_time,submit_time) < 5 and score < 60

2023-10-04

0 195

题解 | #更新记录（二）#

update exam_record set submit_time = '2099-01-01 00:00:00',score = 0 where start_time < '2021-09-01' and submit_time is null

2023-10-04

1 314

题解 | #更新记录（一）#

update examination_info set tag = 'Python' where tag = 'PYTHON';

2023-10-04

0 237

题解 | #插入记录（三）#

replace into examination_info(exam_id,tag,difficulty,duration,release_time) values(9003,'SQL','hard',90,'2021-01-01 00:00:00')

2023-10-04

0 204

题解 | #插入记录（二）#

insert into exam_record_before_2021(uid,exam_id,start_time,submit_time,score) select uid,exam_id,start_time,submit_time,score from exam_record where ...

2023-10-04

0 200

题解 | #插入记录（一）#

insert into exam_record(uid,exam_id,start_time,submit_time,score) values( 1001,9001,"2021-09-01 22:11:12","2021-09-01 23:01:12",90...

2023-10-04

0 192

题解 | #纠错4#

SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'MI' UNION SELECT cust_name, cust_contact, ...

2023-09-28

0 197

题解 | #将两个 SELECT 语句结合起来（二）#

select prod_id, quantity from OrderItems where quantity = 100 union select prod_id, quantity from OrderItems where p...

2023-09-28

0 340

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

# 导入Pandas库 import pandas as pd # 从CSV文件中读取销售数据 data = pd.read_csv('sales.csv') # 计算R、F、M分位数并将结果转换为字符串类型 recenct_rank = pd.qcut(data['recency'], [0,...

2023-09-28

0 310

题解 | #按照等级递增序查看牛客网用户信息#

# 导入pandas库，并将其重命名为pd import pandas as pd # 设置pandas的显示选项，以改变输出格式 # 设置显示宽度，以便更好地查看数据（每行最多300个字符） pd.set_option("display.width", 300) # 设置显示...

2023-09-28

0 318