Changes between Initial Version and Version 1 of AdvancedReport20

Timestamp:

12/28/25 23:20:54 (5 days ago)

Author:

211101

Comment:

--

AdvancedReport20

@@ +1 @@
+===== Трансакции според тагови со највисоко трошење за цел систем
+{{{#!sql
+SELECT 
+    tg.tag_name, 
+    SUM(tb.spent_amount) AS total_spent
+FROM 
+    transaction_breakdown tb
+JOIN transaction t ON tb.transaction_id = t.transaction_id
+JOIN tag_assigned_to_transaction tat ON t.transaction_id = tat.transaction_id
+JOIN tag tg ON tat.tag_id = tg.tag_id
+GROUP BY 
+    tg.tag_name
+ORDER BY 
+    total_spent DESC;
+}}}