我的项目考勤管理系统。我希望在数据库注册(姓名、电子邮件、密码、主题)中显示特定学生表注册后的出勤率(姓名、电子邮件、注册、学期、密码、分支)(注册、主题、出勤率、日期、faculty_id)
发布于 2020-04-12 13:45:15
我要在这里假设几件事。对于出勤栏,如果学生在那个特定的日期在场,我将假设“是”,如果不是这样,我将假设“不是”。
SELECT f.name, f.subject, t2.attendance_percentage
FROM fsignup f
JOIN (SELECT subject, Yes/SUM(Yes+No)*100 AS attendance_percentage FROM (SELECT subject, SUM(CASE WHEN attendance="Yes" THEN 1 ELSE 0) AS Yes, SUM(CASE WHEN attendance="No" THEN 1 ELSE 0) AS No FROM attendance GROUP BY subject)t1)t2
ON f.subject=t2.subject
GROUP BY f.name, f.subjecthttps://dba.stackexchange.com/questions/264762
复制相似问题