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

Timestamp:

02/12/22 15:23:42 (3 years ago)

Author:

186102

Comment:

--

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

@@ -28 +28 @@
                 select count(d.delivery_id) as cnt ,d.distributor_id, d.delivery_id
                 from project.delivery as d
-                where now() - interval'3 months' <= d."date"
+                where status='Delivered' AND now() - interval'3 months' <= d."date"
                 group by d.delivery_id, d.distributor_id
 )as d on o.distributor_id = d.distributor_id
 group by o.distributor_id
-order by Br_Dostaveni_Produkti desc;
+order by Br_Dostaveni_Produkti desc
+limit 1;
 }}}