福状元

题解

/ 注册

全部文章 / 题解（共2篇）

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

select device_id,question_id,result from question_practice_detail where device_id in( select device_id from user_profile where university = '浙江大学' );

Mysql

2022-01-19

0 379

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

select university, avg(question_cnt) as avg_question_cnt, avg(answer_cnt) as avg_answer_cnt from user_profile group by university having avg_question_...

Mysql

2022-01-19

0 319