垫底菜鸡

分类

/ 注册

全部文章（共53篇）

题解 | 多组_二维数组_T组形式

import sys l = int(input()) for i in range(l): res = 0 n,m = map(int,input().split()) for j in range(n): w = sum(map(int,input()...

2025-09-03

0 55

题解 | 单组_二维数组

import sys n,m = map(int,input().split()) res = 0 for i in range(n): w = sum(map(int,input().split())) res = res + w print(res) 第一块用map是为了将格...

2025-09-03

0 31

题解 | 单组_A+B

for line in sys.stdin: a,b = map(int,line.split()) print(a+ b)

2025-09-01

1 75

题解 | #分别满足两个活动的人#

select uid, 'activity1' as activity from exam_record where year (submit_time) = 2021 group by uid having min(score) >= 85 u...

2023-03-10

0 329

题解 | #作答试卷得分大于过80的人的用户等级分布#

select level, count(ui.uid) as level_cnt from exam_record as er join examination_info as ei on er.exam_id = ei.exam_id join user_info ui on er....

2023-03-09

0 297

题解 | #试卷发布当天作答人数和平均分#

select exam_id, count(distinct uid) as uv, round(avg(score),1) as avg_score from exam_record where (exam_id,date(start_time)) in ( s...

2023-03-09

0 301

题解 | #月总刷题数和日均刷题数#

select coalesce(year_mon,'2021汇总') as submit_month, count(question_id) as month_q_cnt, round(count(question_id)/max(t.days_month),3) as avg_day_cnt fr...

2023-03-08

0 278

题解 | #平均活跃天数和月活人数#

select date_format(submit_time, '%Y%m') as month, round((count(distinct uid, date_format(submit_time, '%y%m%d'))) / count(distinct uid), 2) as ...

2023-03-08

0 317

题解 | #得分不小于平均分的最低分#

select min(score) as min_score_over_avg from exam_record join examination_info using(exam_id) where tag= 'SQL' and score >= ( select avg(score)...

2023-03-08

0 329

题解 | #创建一张新表#

create table if not exists user_info_vip( id int primary key auto_increment comment '自增ID', uid int unique not null comment '用户ID', nick_n...

2023-03-07

0 257