Changes between Version 9 and Version 10 of AdvancedReports

Timestamp:

01/19/22 16:01:10 (2 years ago)

Author:

193060

Comment:

--

AdvancedReports

@@ -56 +56 @@
 fetch first row only;
 }}}
+
+== Прикажување на најчитаната книга на еден автор за одреден временски период
+{{{#!sql
+select * from pozajmica;
+select k.naslov, a.ime, count(p.id_na_pozajmica) as pozajmuvanja from
+pozajmica as p
+
+join knigi as k on p.id_na_kniga=k.id_na_kniga
+join izdava as i on k.id_na_kniga = i.id_knigi
+join avtor as a on i.id_avtor = a.id_na_avtor
+where a.ime like '%Goce%' and p.datum_na_zemanje between now() - interval'1 month' and now()
+
+group by 1,2
+order by pozajmuvanja desc
+fetch first row only;
+}}}