Changes between Version 1 and Version 2 of WikiStart/Analytics

Timestamp:

03/23/25 21:47:32 (12 days ago)

Author:

203206

Comment:

db

WikiStart/Analytics

@@ -1 +1 @@
 = Аналитика и статистика
+
+
+== Детален преглед на трансакции помеѓу корисниците по датум 
+{{{
+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; 
+
+
+}}}
+
+== 
+