ðÒÉ×ÅÔ. åÓÔØ ÔÁËÏÊ ÚÁÐÒÏÓ.
select simple_raspisanie.DISCIPLINA_ID,simple_vedomost.student_id
,sum(case when simple_vedomost.mark_id = 1 then 1 else 0 end) as mark_id1
,sum(case when simple_vedomost.mark_id = 2 then 1 else 0 end) as mark_id2
,sum(case when simple_vedomost.mark_id = 3 then 1 else 0 end) as mark_id3
,sum(case when simple_vedomost.mark_id = 4 then 1 else 0 end) as mark_id4
,sum(case when simple_vedomost.mark_id = 5 then 1 else 0 end) as mark_id5
,sum(case when simple_vedomost.mark_id = 6 then 1 else 0 end) as mark_id6
,sum(case when simple_vedomost.mark_id = 7 then 1 else 0 end) as mark_id7
,sum(case when simple_vedomost.mark_id = 8 then 1 else 0 end) as mark_id8
,sum(case when simple_vedomost.mark_id = 9 then 1 else 0 end) as mark_id9
, count(propuski.c) asd
, sum(case when SP_PROPUSK_PRICHINA_WHAT_FULL.flag = 4 then
case when sp_propusk_prichina_what_full.para_no =
simple_raspisanie.para then 1 else 0 end
else 0
end)
, sum(case when SP_PROPUSK_PRICHINA_WHAT_FULL.flag = 1 then
case when sp_propusk_prichina_what_full.lesson_type_id =
simple_raspisanie.lesson_type_id then 1 else 0 end
else 0
end)
, sum(case when SP_PROPUSK_PRICHINA_WHAT_FULL.flag = 2 then
case when sp_propusk_prichina_what_full.lesson_type_id =
simple_raspisanie.lesson_type_id then 1 else 0 end
else 0
end)
, sum(case when SP_PROPUSK_PRICHINA_WHAT_FULL.flag = 3 then
case when sp_propusk_prichina_what_full.disciplina_id =
simple_raspisanie.disciplina_id then 1 else 0 end
else 0
end)
from simple_raspisanie
left join simple_vedomost on simple_vedomost.simple_raspisanie_id =
simple_raspisanie.c
left join students_pool on students_pool.c = simple_vedomost.student_id
left join propuski on propuski.student_id = simple_vedomost.student_id and
simple_raspisanie.datee between propuski.from_date and propuski.to_date
left join SP_PROPUSK_PRICHINA_WHAT_FULL on
SP_PROPUSK_PRICHINA_WHAT_FULL.propusk_prichina_id = propuski.prichina_id
where exists(select c from propuski where propuski.student_id =
simple_vedomost.student_id)
group by 2,1
ÐÒÏÂÌÅÍÁ : åÓÌÉ ÌÉÎËÏ×ÁÔØ ÔÁÂÌÉÃÕ SP_PROPUSK_PRICHINA_WHAT_FULL, ÔÏ
ÎÅÐÒÁ×ÉÌØÎÏ ÓÞÉÔÁÅÔ mark_id1-9.
óÞÉÔÁÅÔ ÏÎÁ ÎÅÐÒÁ×ÉÌØÎÏ ÐÏÔÏÍÕ ÞÔÏ × ÎÅÊ ÎÁ ÏÄÉÎ propusk_prichina_id ÖÅÔ
ÂÙÔØ ÎÅÓËÏÌØËÏ ÚÁÐÉÓÅÊ. åÓÌÉ ÉÈ ÂÏÌØÛÅ ÏÄÎÏÊ - ÐÏÌÕÞÁÅÔÓÑ ÎÅÐÒÁ×ÉÌØÎÙÊ
ÐÏÄÓÞÅÔ mark_id1-9.
þÔÏ × ÚÁÐÒÏÓÅ ÐÏÄÐÒÁ×ÉÔØ ÞÔÏÂÙ ÎÏÒÍÁÌØÎÏ ÏÔÒÁÂÏÔÁÌ?
ó Õ×ÁÖÅÎÉÅÍ,
áÎÄÒÅÊ
P.S. õ ÍÅÎÑ ÞÔÏ-ÔÏ ÐÏÞÔÁ ÐÌÏÈÏ ÈÏÄÉÔ. äÒÕÇÏÊ ÐÏÓÔ ÐÏÓÙÌÁÌ ÎÅÄÅÌÀ ÎÁÚÁÄ - ÔÁË
ÏÎ ÓÄÅÓØ É ÎÅ ÐÏÑ×ÉÌÓÑ. ëÁË ÐÒÏ×ÅÒÉÔØ ÐÏÞÔÏ×ÉË?
--~--~---------~--~----~------------~-------~--~----~
-~----------~----~----~----~------~----~------~--~---
