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

Timestamp:

02/12/22 19:57:21 (3 years ago)

Author:

186102

Comment:

--

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

@@ -16 +16 @@
 sum(case when extract(month from ph.dates) =11 and now() - interval'12 months' <= ph.dates then ph.price end)/count(case when extract(month from ph.dates) =11 and now() - interval'12 months' <= ph.dates then ph.price end) as Noemvri,
 sum(case when extract(month from ph.dates) =12 and now() - interval'12 months' <= ph.dates then ph.price end)/count(case when extract(month from ph.dates) =12 and now() - interval'12 months' <= ph.dates then ph.price end) as Dekemvri
+
 from project.price_history as ph
 where prod_id = 3250;