Changes between Version 11 and Version 12 of AdvancedReports

Timestamp:

01/24/22 15:11:36 (3 years ago)

Author:

193076

Comment:

--

AdvancedReports

@@ -72 +72 @@
 fetch first row only;
 }}}
+
+== Прикажување колку често корисниците се најавувале во даден временски интервал
+{{{#!sql
+select ch.ime,ch.prezime,(count(a.log_id)) as najavuvanja
+from authentication as a
+
+join chovek as ch on a.id_chovek = ch.id_chovek
+where a.timestamp_log between now() - interval '2 weeks' and now()
+
+group by 1,2
+order by najavuvanja desc
+}}}