Lion灬Heart

分类

题解(13)

/ 注册

全部文章（共6篇）

题解 | #统计每个学校各难度的用户平均刷题数#

select up.university, qd.difficult_level, count(qpd.question_id)/count(distinct up.device_id) #注意，问题数量可有重复，但设备（即用户）不能重复 from user_prof...

Mysql

2022-01-07

1 369

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

方法一连表查询 select qpd.device_id,qpd.question_id,qpd.result FROM question_practice_detail as qpd inner join user_profile as up on qpd.device_id = up.devi...

Mysql

2021-12-31

0 417

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

# 方法一连表查询 # select qpd.device_id,qpd.question_id,qpd.result FROM # question_practice_detail as qpd inner join user_profile as up on qpd.device_id = u...

Mysql

2021-12-31

2 388

题解 | #获取有奖金的员工相关信息。#

select e.emp_no , e.first_name , e.last...

Mysql

2021-09-30

0 388

题解 | 三表连接

旧SQL语句: SELECT DISTINCT ( m.music_name ) FROM follow AS f LEFT JOIN music_likes AS ml ON f.follower_id = ml.user_id INNER JOIN music AS m ON ml.m...

Mysql

2021-09-30

10 1645

题解 | #获得积分最多的人(一)#

# 方法一 select gs.name , max(`grade_sum`) from ( SELECT u.name , SUM(g.grade_num) as `grade_sum` FROM user as u inner join grade_info as g on u.id...

Mysql

2021-09-23

3 595