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

Timestamp:

02/13/22 23:03:27 (3 years ago)

Author:

186102

Comment:

--

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

@@ -131 +131 @@
 == Број нарачки за секој квартал годинава ==
 {{{#!sql
-
+select sum(prv.cnt) as Prv_Kvartal , sum(vtor.cnt1) as Vtor_Kvartal, sum(tret.cnt2) as Tret_Kvartal, sum(cetvrt.cnt3) as Cetvrt_Kvartal
+from(
+        select count(d.delivery_id) as cnt
+        from project.delivery as d
+        where extract(year from d.date) = extract(year from now()) and extract(month from d.date) <=3
+        --group by d.date,d.delivery_id
+)as prv,
+(
+        select count(d.delivery_id) as cnt1
+        from project.delivery as d
+        where extract(year from d.date) = extract(year from now()) and extract(month from d.date) > 3 and extract(month from d.date) <=6
+        --group by d.date,d.client_id
+)as vtor,
+(
+        select count(d.client_id) as cnt2
+        from project.delivery as d
+        where extract(year from d.date) = extract(year from now()) and extract(month from d.date) > 6 and extract(month from d.date) <=9
+        --group by d.date,d.client_id
+)as tret,
+(
+        select count(d.client_id) as cnt3
+        from project.delivery as d
+        where extract(year from d.date) = extract(year from now()) and extract(month from d.date) > 9 and extract(month from d.date) <=12
+        --group by d.date,d.client_id
+)as cetvrt
 }}}