Changes between Version 26 and Version 27 of Напредни извештаи од базата

Timestamp:

02/13/22 22:41:53 (3 years ago)

Author:

186102

Comment:

--

Напредни извештаи од базата

@@ -117 +117 @@
 }}}
 
+== Вкупно продадени продукти по категорија ==
+{{{#!sql
+
+        select distinct pr.type, sum(cp.quantity)
+        from project.contains_product as cp
+        join project.product as pr on pr.prod_id = cp.prod_id
+        join project.cart as crt on crt.cart_id = cp.cart_id
+        join project.checkout as chk on chk.cart_id = crt.cart_id
+        join project.order as o on o.order_id = chk.order_id
+        where o.order_status = 'Processed'
+        group by pr."type"
+}}}