题解 | #计算单次平均刷题数#
计算单次平均刷题数
https://www.nowcoder.com/practice/215a2391bfec4abca05c94812d94da83
select sum(pass_count)/count(user_id) as 'avgCnt' from questions_pass_record_detail
1.from 表名
2.sum(列名)/count(列名)
3.组合起来
计算单次平均刷题数
https://www.nowcoder.com/practice/215a2391bfec4abca05c94812d94da83
select sum(pass_count)/count(user_id) as 'avgCnt' from questions_pass_record_detail
1.from 表名
2.sum(列名)/count(列名)
3.组合起来
相关推荐