yub4by

题解

/ 注册

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

题解 | #统计每个用户的平均刷题数#

SELECT t1.university, t3.difficult_level, COUNT(t2.question_id) / COUNT(DISTINCT(t2.device_id)) as avg_answer_cnt from user_profile ...

Mysql

2021-09-20

442 14695