Changes between Version 4 and Version 5 of WikiStart/Analytics

Timestamp:

03/23/25 22:51:01 (2 months ago)

Author:

203206

Comment:

db3

WikiStart/Analytics

@@ -76 +76 @@
 }}}
 
+== Максимум, минимум и просечен износ на сума по трансакција во одредена валута
 
+{{{
 
+SELECT 
+        max(t.amount) as maximum,
+        avg(t.amount) as "average",
+        min(t.amount) as minimum
+    
+FROM 
+    transferred_money tm
+JOIN 
+    account a_s ON tm.s_account_id = a_s.id
+JOIN 
+    account a_r ON tm.r_account_id = a_r.id
+JOIN
+    "transaction" t ON tm.t_id = t.id
+WHERE currency='USD';
+}}}
+