Changes between Version 7 and Version 8 of WikiStart/Analytics

Timestamp:

03/30/25 21:26:19 (2 months ago)

Author:

203206

Comment:

db

WikiStart/Analytics

@@ -161 +161 @@
 LIMIT 3; 
 }}}
+
+== Корисници со највисок износ на депозити
+
+{{{
+
+WITH deposit_totals AS (
+    SELECT account_id, SUM(amount) AS total_deposit
+    FROM deposit
+    GROUP BY account_id
+)
+
+SELECT a.id AS account_id,
+       a.username,
+       a.email,
+       COALESCE(dt.total_deposit, 0) AS total_deposit,
+       RANK() OVER (ORDER BY COALESCE(dt.total_deposit, 0) DESC) AS deposit_rank
+FROM account a
+LEFT JOIN deposit_totals dt ON a.id = dt.account_id
+ORDER BY deposit_rank
+LIMIT 3; 
+}}}