Changes between Version 5 and Version 6 of AdvancedReports

Timestamp:

01/18/22 23:15:18 (3 years ago)

Author:

193270

Comment:

--

AdvancedReports

@@ -44 +44 @@
 and p.datum_na_zemanje between now() - interval'3 weeks' and now()
 }}}
+
+== Прикажување на најдобро оценетата книга во даден временски интервал
+{{{
+select k.naslov, avg(ocena) as prosecna_ocena from ocena as o
+
+join knigi as k on o.ocena_id_kniga = k.id_na_kniga
+join pozajmica as p on k.id_na_kniga = p.id_na_kniga
+
+where p.datum_na_vrakjanje between now() - interval '2 weeks' and now()
+group by 1
+order by prosecna_ocena desc
+fetch first row only;
+}}}