Changes between Version 3 and Version 4 of ReportsProcedures

Timestamp:

09/23/25 11:10:28 (5 hours ago)

Author:

223075

Comment:

--

ReportsProcedures

@@ -20 +20 @@
 }}}
 
-Мерч – број на продажби и бруто приход:
-(доколку имате колонa quantity во "User_Purchased_Merch", заменете COUNT() со SUM(COALESCE(upm.quantity,1)) и помножете со price)*
 
-{{{
-#!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;
-}}}