小马仔仔

题解

/ 注册

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

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

select t1.device_id, t1.question_id, t1.result from question_practice_detail as t1 inner join user_profile&nbs...

Mysql

2022-02-24

1 247

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

select gender, university, count(device_id) as user_num, round(avg(active_day...

Mysql

2022-02-24

22 3046

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

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

Mysql

2022-02-24

20 2192