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

Timestamp:

02/13/22 21:09:09 (3 years ago)

Author:

186102

Comment:

--

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

@@ -54 +54 @@
 == 5 Најпопуларни конфигурации во изминатите 6 месеци ==
 {{{#!sql
-
+select distinct c."name", count(oc.config_id) as cnt
+from project."Configuration" as c
+join project.orders_configuration as oc on oc.config_id = c.config_id
+join project."order" as o on o.order_id = oc.order_id 
+join project.delivery as dlv on dlv.delivery_id = o.delivery_id
+where now() - interval'6 months' <= dlv."date" and dlv.status = 'Delivered'
+group by c.name, oc.config_id
+order by cnt desc
+limit 5;
 }}}