Seechuan

分类

题解(29)

/ 注册

全部文章（共35篇）

题解 | #浙大不同难度题目的正确率#

select difficult_level, avg(if(qpd.result='right', 1, 0)) as correct_rate #sum(if(qpd.result='right', 1, 0)) / count(qpd.question_id) as corre...

2023-06-21

0 199

题解 | #提取博客URL中的用户名#

select device_id,substring(blog_url,11) from user_submit

2023-06-20

0 186

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

SELECT device_id,gender, CASE WHEN age < 20 THEN '20岁以下' WHEN age >= 20 and age<=24 THEN '20-24岁' WHEN age >= 25 then...

2023-06-20

0 190

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

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

2023-06-19

0 185

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

select university,count(question_practice_detail.question_id) / count(distinct question_practice_detail.device_id) as avg_answer_cnt from question_pra...

2023-06-19

0 226

题解 | #分组过滤练习题#

select t.university,t.avg_question_cnt,t.avg_answer_cnt from( select university,avg(question_cnt) as avg_question_cnt,avg(answer_cnt) as avg_answe...

2023-06-15

0 177

题解 | #提取不重复的整数#

#include <iostream> using namespace std; int main() { int n; while (cin >> n) { // 注意 while 处理多个 case bool seen[10]={0}; ...

2023-04-17

0 203

题解 | #取近似值#

#include <iostream> using namespace std; int main() { string s; while (cin >> s) { // 注意 while 处理多个 case int n=s.size(); ...

2023-04-13

0 206

题解 | #质数因子#

#include <iostream> using namespace std; void divisor(long long n,long long d){ if(n==1) return; while(n%d!=0){ if(n&l...

2023-04-13

0 171

题解 | #进制转换#

#include <iostream> #include<map> using namespace std; int main() { map<char,int> Map; Map['0']=0; Map['1']=1; Map[...

2023-04-13

0 228