牛客558186998号

题解

/ 注册

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

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

注意不要用where,用having select university, avg(question_cnt) as avg_question_cnt, avg(answer_cnt) as avg_answer_cnt from user_profile group by university h...

Mysql

2022-06-25

0 331

题解 | #21年8月份练题总数#

select count(distinct device_id) as did_cnt, count(question_id) as question_cnt from question_practice_detail where date like '2021-08%';

Mysql

2022-06-25

0 219