Changes between Version 8 and Version 9 of AdvancedReports

Timestamp:

01/19/22 01:58:35 (2 years ago)

Author:

193060

Comment:

--

AdvancedReports

@@ -45 +45 @@
 }}}
 
+== Прикажување на најдобро оценетата книга 
+{{{#!sql
+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
+
+group by 1
+order by prosecna_ocena desc
+fetch first row only;
+}}}