Changes between Version 3 and Version 4 of WikiStart/Analytics

Timestamp:

03/23/25 22:43:22 (2 months ago)

Author:

203206

Comment:

mk1

WikiStart/Analytics

@@ -50 +50 @@
 }}}
 
+
+== Трансакции по валута, подредени по време
+{{{
+SELECT 
+    tm.s_account_id AS sender_id,
+        a_s.username AS sender_username,
+        tm.r_account_id AS receiver_id,
+        a_r.username AS receiver_username,
+    tm.t_id,
+        t.timestamp,
+        t.amount,
+        tm.currency
+    
+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='EUR'
+ORDER BY timestamp;
+
+}}}
+
+
+