SELECT machine_id,ROUND(SUM(IF(activity_type='end',timestamp,timestamp*-1))/count(distinct process_id),3) processing_time
FROM Activity
GROUPBY machine_id
1.3 运行截图
2 员工奖金
2.1 题目内容
2.1.1 基本题目信息
2.1.2 示例输入输出
2.2 示例sql语句
# 根据输出示例可知: null值也是需要被统计在内的SELECT e.name,b.bonus
FROM Employee e
LEFTJOIN Bonus b
ON e.empId=b.empId
WHERE b.bonus<1000OR b.bonus ISNULL
2.3 运行截图
3 学生们参加各科测试的次数
3.1 题目内容
3.1.1 基本题目信息1
3.1.2 基本题目信息2
3.1.3 示例输入输出
a 示例输入
b 示例输出
3.2 示例sql语句
SELECT t1.student_id,t1.student_name,t1.subject_name,
IFNULL(t2.num,0) attended_exams
FROM(SELECT s1.student_id,s1.student_name,s2.subject_name
FROM Students s1
CROSSJOIN Subjects s2
)t1
LEFTJOIN(SELECT student_id,subject_name,count(*) num
FROM Examinations e
GROUPBY student_id,subject_name
)t2
ON t1.student_id=t2.student_id AND t1.subject_name=t2.subject_name
ORDERBY t1.student_id asc,t1.subject_name asc