Changes between Version 6 and Version 7 of AdvancedReports

Timestamp:

01/19/22 01:45:13 (3 years ago)

Author:

193060

Comment:

--

AdvancedReports

@@ -45 +45 @@
 }}}
 
-== Прикажување на најдобро оценетата книга во даден временски интервал
-{{{
-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;
-}}}