Changes between Initial Version and Version 1 of AdvancedReport19

Timestamp:

12/28/25 23:20:22 (5 days ago)

Author:

211101

Comment:

--

AdvancedReport19

@@ +1 @@
+===== Најчести времиња за трансакции
+Во кој час од денот корисниците најчесто вршат трансакции
+{{{#!sql
+SELECT 
+    EXTRACT(HOUR FROM t.date) AS transaction_hour, 
+    COUNT(*) AS transaction_count
+FROM 
+    transaction t
+GROUP BY 
+    transaction_hour
+ORDER BY 
+    transaction_count DESC;
+}}}