急,急,急 pl/sql ,oracle 根据查询结果统计数量

发布网友 发布时间：2023-07-10 04:12

我来回答

共4个回答

热心网友 时间：2023-10-11 20:11

select A.calssno, A.count_1, B.count_2, C.count_3
from
(select count(*) as count_1, calssno
from student_mart
where project = '语文'
and mark = 'D'
group by calssno) A,
(select count(*) as count_2, calssno
from student_mart
where project = '数学'
and mark = 'D'
group by calssno) B,
(select count(*) as count_3, calssno
from student_mart
where project = '英语'
and mark = 'D'
group by calssno) C
where A.calssno = B.calssno
and B.calssno = C.calssno

热心网友 时间：2023-10-11 20:11

SELECT calssno, 语文成绩为A的条数=COUNT(CASE WHEN project='语文' AND mark='A' THEN 1 END),数学成绩为B的条数=COUNT(CASE WHEN project='数学' AND mark='B' THEN 1 END),
英语成绩为C的条数=COUNT(CASE WHEN project='英语' AND mark='C' THEN 1 END)
FROM student_mart

GROUP BY calssno

热心网友 时间：2023-10-11 20:11

select count(*) from student_mart where mark='D' and project='语文'

union

select count(*) from student_mart where mark='D' and project='数学'
union

select count(*) from student_mart where mark='D' and project='英语'

热心网友 时间：2023-10-11 20:12

select project,count(*) from student_mart t where t.mark='D' group by t.project