龙灬胆

分类

/ 注册

全部文章（共43篇）

题解 | 计算日期到天数转换

while True: try: string = input().split() year = int(string[0]) month = int(string[1]) day = int(string[2]) ...

2025-12-24

0 22

题解 | 分数线划定

while True: try: nums = input().split() n = int(nums[0]) m = int(nums[1]) t = int(1.5 * m) records = {} ...

2025-12-22

0 18

题解 | 构造A+B

while True: try: string = input() n = int(string.split(' ', 1)[0]) k = int(string.split(' ', 1)[1]) if n >= 2 a...

2025-12-21

0 22

题解 | 构造A+B

while True: try: string = input() n = int(string.split(' ', 1)[0]) k = int(string.split(' ', 1)[1]) if n >= 2 a...

2025-12-21

0 17

题解 | #计算用户8月每天的练题数量#

select day (date) as day, count(question_id) as question_cnt from question_practice_detail where month (date) = 8 and year (date) ...

2024-03-03

0 211

题解 | #查看不同年龄段的用户明细#

select device_id, gender, #多种情况使用when在case中分别讨论 ( case when age < 20 then '20岁以下' when age between 20 ...

2024-03-03

0 242

题解 | #计算25岁以上和以下的用户数量#

select ( case when age >= 25 then '25岁及以上' else '25岁以下' end ) as age_cut, count(*) as number fr...

2024-03-03

0 192

题解 | #统计每个用户的平均刷题数#

select university, difficult_level, round( count(qpd.device_id) / count(distinct qpd.question_id), 4 ) as avg_answer_c...

2024-03-03

0 248

题解 | #统计每个学校各难度的用户平均刷题数#

select university, difficult_level, #注意distinct qpd.device_id round( count(qpd.question_id) / count(distinct qpd.device_id), ...

2024-03-03

0 200

题解 | #统计每个学校的答过题的用户的平均答题数#

select university, #注意distinct qpd.device_id要指明对qpd或up表中的device_id去重，否则无法明确是哪个device_id round(count(question_id) / count(distinct qpd.device_...

2024-03-03

0 219