Changes between Initial Version and Version 1 of AdvancedReport18

Timestamp:

12/28/25 23:20:08 (6 days ago)

Author:

211101

Comment:

--

AdvancedReport18

@@ +1 @@
+===== Сметки со највисоко вкупно трошење во изминатата година
+{{{#!sql
+SELECT 
+    ta.account_name, 
+    SUM(tb.spent_amount) AS total_spent
+FROM 
+    transaction_breakdown tb
+JOIN transaction t ON tb.transaction_id = t.transaction_id
+JOIN transaction_account ta ON tb.transaction_account_id = ta.transaction_account_id
+WHERE 
+    t.date >= NOW() - INTERVAL '1 YEAR'
+GROUP BY 
+    ta.account_name
+ORDER BY 
+    total_spent DESC
+LIMIT 10;
+}}}