Changes between Version 3 and Version 4 of AdvancedReports

Timestamp:

01/24/24 16:13:27 (12 months ago)

Author:

175012

Comment:

--

AdvancedReports

@@ -32 +32 @@
 ORDER BY 
     usage_count DESC;
+
+}}}
+
+=== Преференца на клиентот за број на денови според неговите објави за Travel Health полиса за минатата година во опаѓачки редослед ===
+
+{{{#!sql
+
+select
+        'Travel Health' as Typepolicy,
+    COUNT(*) AS posts_count,
+    (p.edate::DATE - p.sdate::DATE) AS average_days_preference
+FROM
+    project."policy" as p
+JOIN 
+    project.Pol_travel AS Pt ON p.p_id  = Pt.pol_id 
+WHERE 
+    EXTRACT(YEAR FROM p.edate) = EXTRACT(YEAR FROM CURRENT_DATE) - 1
+GROUP BY 
+   average_days_preference
+order by average_days_preference desc
 
 }}}