WW在搜寻
WW在搜寻
全部文章
分类
错题(1)
题解(59)
归档
标签
去牛客网
登录
/
注册
WW在搜寻的博客
全部文章
(共35篇)
题解 | #统计每个学校各难度的用户平均刷题数#
SELECT u.university,qe.difficult_level ,COUNT(qe.question_id) / COUNT(DISTINCT q.device_id) AS avg_answer_cnt FROM user_profile u JOIN question_pract...
Mysql
2022-01-14
0
224
题解 | #浙江大学用户题目回答情况#
SELECT device_id,question_id,result FROM question_practice_detail WHERE device_id=( SELECT device_id FROM user_profile WHERE university='浙江大学' );
Mysql
2022-01-13
0
174
题解 | #分组过滤练习题#
SELECT university, AVG(question_cnt) AS avg_question_cnt, AVG(answer_cnt) AS avg_answer_cnt FROM user_profile GROUP BY university HAVING avg_questi...
Mysql
2022-01-13
0
176
题解 | #分组计算练习题#
SELECT gender,university,COUNT(*) user_num, ROUND(AVG(active_days_within_30),1) avg_active_day,ROUND(AVG(question_cnt),1) avg_question_cnt FROM user_p...
Mysql
2022-01-13
1
231
题解 | #Where in 和Not in#
SELECT device_id,gender,age,university,gpa FROM user_profile WHERE university IN('北京大学','复旦大学','山东大学'); #SELECT device_id,gender,age,university,gpa #F...
Mysql
2022-01-13
0
181
首页
上一页
1
2
3
4
下一页
末页