Changes between Version 6 and Version 7 of ReportsProcedures

Timestamp:

09/23/25 11:42:38 (4 hours ago)

Author:

223075

Comment:

--

ReportsProcedures

@@ -19 +19 @@
 }}}
 
+== 2) Популарност и приходи: Merch ==
+Мерч – број на продажби и бруто приход:
 
+{{{
+#!sql
+SELECT
+m.item_name,
+COUNT(*) AS num_sales,
+SUM(m.price) AS gross_revenue
+FROM "User_Purchased_Merch" upm
+JOIN "Merch_Items" m ON m.merch_id = upm.merch_id
+GROUP BY m.item_name
+ORDER BY gross_revenue DESC, num_sales DESC;
+}}}
+
+