Changes between Version 2 and Version 3 of AdvancedReports

Timestamp:

01/18/22 22:10:41 (3 years ago)

Author:

193270

Comment:

--

AdvancedReports

@@ -13 +13 @@
 fetch first row only;
 }}}
+
+== Прикажување на членот што има прочитано највеќе книги во последниот месец
+{{{
+select ch.ime,ch.prezime,(count(ch.id_chovek)) as pozajmuvanja
+from pozajmica as p
+join chlen as chl on p.id_chovek_prave = chl.id_chovek
+join chovek as ch on chl.id_chovek = ch.id_chovek
+join knigi as k on p.id_na_kniga = k.id_na_kniga
+where p.datum_na_zemanje between now() - interval'1 month' and now()
+group by 1,2
+order by pozajmuvanja desc
+fetch first row only;
+}}}