Changes between Version 2 and Version 3 of WikiStart/Analytics

Timestamp:

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

Author:

203206

Comment:

c1

WikiStart/Analytics

@@ -25 +25 @@
 }}}
 
-== 
+== Трансакции до одреден датум и време
+{{{
+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
+    
+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
+      timestamp<'2025-03-23 20:30:00.000000';
 
+
+}}}
+