Changes between Initial Version and Version 1 of AdvancedReports

Timestamp:

05/20/21 15:34:46 (4 years ago)

Author:

153081

Comment:

--

AdvancedReports

@@ +1 @@
+= Апликативен дизајн - Случаи на употреба и Сценарија за пристап до базата - SQL Погледи
+
+== Погледи 
+
+=== Поглед за наоѓање на најдобри клиенти 
+{{{#!sql
+create view  najdobri_klienti as 
+select 
+k.id_klient ,k.korisnicko_ime ,k.prezime 
+from klienti as k
+inner join naracka as n on k.id_klient =n.id_klient 
+where n.vkupna_cena in
+(select max(n.vkupna_cena)
+from naracka as n
+inner join klienti as k on n.id_klient =k.id_klient) ;
+}}}
+
+=== Поглед за наоѓање на најдобри работници
+{{{#!sql
+create view  najdobri_vraboteni_po_naracka as
+select 
+n .naslov ,v.ime ,v.prezime ,max(enid.br_na_zavrseni_delovi)
+from  naracka as n 
+inner join evidencija_na_naracki as enn on n.id_naracka =enn .id_naracka 
+inner join evidencija_naracki_izraboteni_delovi as enid on enn.id_evidencija =enid.id_evidencija 
+inner join delovi as d on enid.id_del =d.id_del 
+inner join delovi_izraboteni_od_mashina as diom on d.id_del =diom .id_del 
+inner join mashini as m on diom .id_mashina =m.id_mashina 
+inner join vraboteni_vo_proizvodstvo_raboti_na_mashina as vprrm on m.id_mashina =vprrm .id_mashina 
+inner join vraboteni_vo_proizvodstvo as vvp on vprrm .id_vraboten =vvp .id_vraboten 
+inner join vraboteni as v on vvp.id_vraboten =v.id_vraboten 
+group by 1,2,3;
+}}}