Seechuan
Seechuan
全部文章
分类
题解(29)
归档
标签
去牛客网
登录
/
注册
Seechuan的博客
全部文章
(共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
198
题解 | #提取博客URL中的用户名#
select device_id,substring(blog_url,11) from user_submit
2023-06-20
0
184
题解 | #查看不同年龄段的用户明细#
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
189
题解 | #统计每个学校各难度的用户平均刷题数#
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
181
题解 | #统计每个学校的答过题的用户的平均答题数#
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
202
题解 | #取近似值#
#include <iostream> using namespace std; int main() { string s; while (cin >> s) { // 注意 while 处理多个 case int n=s.size(); ...
2023-04-13
0
205
题解 | #质数因子#
#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
168
题解 | #进制转换#
#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
首页
上一页
1
2
3
4
下一页
末页