Changes between Version 6 and Version 7 of AdvancedReports

Timestamp:

12/23/22 12:14:30 (3 years ago)

Author:

192007

Comment:

--

AdvancedReports

@@ -35 +35 @@
 == Најизнајмуван автомобил во текот на изминатите два месеци земено во однос на тековниот датум
 {{{#!sql 
-select v.brand ,
-                v.chassis_number,
-                c.vehicle_id, 
-                m.model_name, 
-                m.color,c3.company_name, 
-                count(*) as nor from contracts c
-        join vehicles v on v.vehicle_id = c.vehicle_id 
-        join models m on v.model_id = m.model_id 
-        join companies c3 on c3.company_id = v.company_id 
-                where (c.signed_date - interval '2 months')<= c.signed_date and c.signed_date <= now()
-                        group by c.vehicle_id , v.brand , v.chassis_number , m.model_name , m.color, c3.company_name
-                                having count(*) = (select max(nor) from 
-                                        (select vehicle_id, count(*) as nor from contracts c2 group by vehicle_id) contracts)
+select
+        v.brand ,
+        v.chassis_number,
+        c.vehicle_id,
+        m.model_name,
+        m.color,
+        c3.company_name,
+        count(*) as br_iznajmuvanja
+from
+        contracts c
+join vehicles v on
+        v.vehicle_id = c.vehicle_id
+join models m on
+        v.model_id = m.model_id
+join companies c3 on
+        c3.company_id = v.company_id
+where
+        (c.signed_date - interval '2 months')<= c.signed_date
+        and c.signed_date <= now()
+group by
+        c.vehicle_id ,
+        v.brand ,
+        v.chassis_number ,
+        m.model_name ,
+        m.color,
+        c3.company_name
+having
+        count(*) = (
+        select
+                max(br_iznajmuvanja)
+        from
+                (
+                select
+                        vehicle_id,
+                        count(*) as br_iznajmuvanja
+                from
+                        contracts c2
+                group by
+                        vehicle_id) contracts)
 }}}