卡啦啦啦

分类

/ 注册

全部文章（共45篇）

题解 | #完全数计算#

def is_perfect_number(n): sum_p_divison: int = 0 for i in range(1, n // 2 + 1): if n % i == 0: sum_p_divison += i if s...

2024-10-01

0 120

题解 | #质数因子#

import math n = int(input()) for i in range(2, int(math.sqrt(n) + 1)): while n % i == 0: print(i, end=" ") n = n // i i...

2024-10-01

0 87

题解 | #计算用户的平均次日留存率#

select count(distinct T2.device_id, T2.date) / count(distinct T1.device_id, T1.date) from question_practice_detail as T1 left join questio...

2024-09-28

0 121

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

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

2024-09-28

0 76

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

select device_id, gender, ( case when age < 20 then '20岁以下' when age between 20 and 24 then '20-24岁' ...

2024-09-28

0 80

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

/* select '25岁以下' as age_cut, count(device_id) from user_profile where age < 25 or age is null group by age_cut union select '25岁及以上' as age_cut, c...

2024-09-28

0 92

题解 | #查找山东大学或者性别为男生的信息#

select device_id, gender, age, gpa from user_profile where university = '山东大学' union all select device_id, gender, ...

2024-09-28

0 77

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

select T1.university, ( count(T2.question_id) / count(distinct T2.device_id) ) as avg_each_q from user_profile T1, questio...

2024-09-28

0 80

题解 | #ps分析-统计VSZ,RSS各自总和#

#!/bin/bash awk '{ vsz_sum += $5 rss_sum += $6 } END { printf("MEM TOTAL\nVSZ_SUM:%.1fM,RSS_SUM:%.3fM",vsz_sum/1024,rss_sum/102...

2024-09-28

0 88

题解 | #业务分析-提取值#

#!/bin/bash #cat nowcoder.txt | awk -F 'VersionLoggerListener.log ' '{print $2}' | sed 's/, /\n/g' cat nowcoder.txt | awk -F 'VersionLoggerListener....

2024-09-28

0 85