克里斯V

分类

题解(24)

/ 注册

全部文章（共26篇）

题解 | #平均播放进度大于60%的视频类别#

这道题关键在于要考虑到播放时长大于视频时长的情况 with t as ( select t1.tag ,avg(case when TIMESTAMPDIFF(SECOND,t2.start_time,t2.end_time) < t1.duration &...

数据库 Mysql

2022-06-16

0 515

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

select t1.university ,count(t2.question_id)/count(distinct t1.device_id) as avg_answer_cnt from user_profile t1 join...

数据库 Mysql

2022-06-15

0 251

题解 | #浙江大学用户题目回答情况#

select t1.device_id ,t2.question_id ,t2.result from user_profile t1 join question_practice_detail t2&n...

数据库 Mysql

2022-06-14

0 218

题解 | #各个视频的平均完播率#

with t as ( select t1.video_id ,count(case when timestampdiff(SECOND,t1.start_time,t1.end_time)&...

Mysql

2022-06-04

0 233

题解 | #统计大写字母个数#

while True: try: s = input() ss = input() if set(s).issubset(set(ss)): print("true") else: ...

Python3

2022-03-29

0 265

题解 | #统计大写字母个数#

import string while True: try: s = input() n = 0 for i in s: if i in string.ascii_uppercase: n...

Python3

2022-03-29

0 240

题解 | #统计每个月兔子的总数#

def func(n): if n < 3: return 1 else: return func(n-2)+func(n-1) while True: try: n = int(input()) prin...

Python3

2022-03-06

2 260

题解 | #蛇形矩阵#

from itertools import accumulate def func(s): l=list(accumulate(range(1,s+1))) ll =[] lll = [] lll.append(l) for i in range(s): ...

Python3

2022-03-06

0 320

题解 | #单词倒排#

def func(s): l = [i if i.isalpha() else ' ' for i in s] l = ''.join(l).split()[::-1] print(' '.join(l)) s = input() func(s)

Python3

2022-03-01

0 280

题解 | #删除字符串中出现次数最少的字符#

from collections import Counter while True: try: i = input() d = dict(Counter(i)) dd = min(d.values()) l = [k for...

Python3 数组

2022-02-27

0 274