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

Timestamp:

02/13/22 15:42:37 (3 years ago)

Author:

186102

Comment:

--

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

@@ -32 +32 @@
 ) as t2
 }}}
+== 5 Најпопуларни производи во изминатите 6 месеци ==
+{{{#!sql
+select distinct p."name" as Name, p.description as description, cnt
+from project.product as p
+join 
+(
+        select cp.prod_id, count(cp.prod_id) as cnt
+        from project.contains_product as cp
+        group by cp.prod_id
+)as t1 on t1.prod_id = p.prod_id
+join project.contains_product as ccp on ccp.prod_id = p.prod_id
+join project.cart as crt on crt.cart_id = ccp.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
+join project.delivery as dlv on o.delivery_id = dlv.delivery_id
+where dlv.status = 'Delivered' and now()-interval'6 months' <= dlv."date"
+order by cnt desc
 
+}}}
 == Просечна цена на продуктот во месец од изминатите 12 месеци ==
 {{{#!sql