芋头炒冰

分类

/ 注册

全部文章（共13篇）

题解 | #分组过滤练习题# 两个注意事项

select university, avg(question_cnt) as avg_question_cnt, avg(answer_cnt) as avg_answer_cnt from user_profile group by university #按学校输出需分组：需要对每个学校统计其...

2023-01-08

0 344

题解 | #分组计算练习题#

select gender, university, count(id), avg(active_days_within_30) as avg_active_day, avg(question_cnt) as avg_question_cnt from user_profile group by g...

2023-01-08

0 275

题解 | #操作符混合运用#

select device_id, gender, age, university, gpa from user_profile where (gpa > 3.5 and university = '山东大学') or (gpa > 3.8 and univer...

2023-01-08

0 213