Changes between Version 4 and Version 5 of AdvancedReports

Timestamp:

01/11/22 00:35:29 (3 years ago)

Author:

193105

Comment:

--

AdvancedReports

@@ -2 +2 @@
 
 == Пациент на кој му се извршени највеќе прегледи
+{{{#!sql
+create view pacient_najmnogu_pregledi as 
+select pacient_id ,covek.ime,covek.prezime, count (pregled.pregled_id) pacientot_bil_na_pregled
+from pacient as p 
+join pregled as pregled on pregled.covek_pacient_id=p.covek_pacient_id
+join covek as covek on covek.covek_id=p.covek_pacient_id
+group by p.pacient_id,covek.covek_id;
+
+select pnp.ime, pnp.prezime ,pnp.pacient_id , pnp.pacientot_bil_na_pregled  as broj_pregledi
+from pacient_najmnogu_pregledi as pnp 
+where pnp.pacientot_bil_na_pregled=
+(select max(pacientot_bil_na_pregled) from pacient_najmnogu_pregledi);
+}}}
 
 == Број на пациенти за секој оддел