芒芒牛

分类

/ 注册

全部文章（共16篇）

题解 | #统计作答次数#

select count(start_time) as total_pv,count(submit_time) as complete_pv,(select count(distinct exam_id) from exam_record where score is not null)as com...

2023-02-24

0 205

题解 | #跳过列表的某个元素#

for i in range(1,16): if i!=13: print(i,end=' ') else: pass

2023-02-22

0 270

题解 | #提前结束的循环#

number=[3, 45, 9, 8, 12, 89, 103, 42, 54, 79] num=int(input()) for i in number: if num==i: break else: print(i)

2023-02-22

0 266

题解 | #累加数与平均值#

要加split才能通过

2023-02-22

0 187

题解 | #验证登录名与密码#

发现用Python2一直不能通过，切换到Python3才行

2023-02-22

0 242

题解 | #国庆期间每类视频点赞量和转发量#

select * from(select tag,dt,sum(like_cnt) over(partition by tag order by dt rows 6 preceding) as sum_like_cnt_7d,max(retweet_cnt) over(partition by ta...

2023-02-21

0 213