Changes between Version 4 and Version 5 of Advanced database reports (SQL and Stored procedures)

Timestamp:

12/21/22 22:25:35 (3 years ago)

Author:

201101

Comment:

--

Advanced database reports (SQL and Stored procedures)

@@ -110 +110 @@
 group by 1,2
 }}}
+
+== Одржана активност за која што има најголема заинтересираност во последната година
+
+
+{{{#!sql
+select a.activity_type as aktivnost,
+       sum(a.number_of_interested_guests) as broj_na_zainteresirani_gosti
+from activities a  
+join reservation_for_activity rfa 
+on a.activity_id  = rfa.activity_id 
+join reservation r  
+on r.reservation_id = rfa.reservation_id 
+where r.start_date  between  now() - interval '1 year' and now()
+group by a.activity_type 
+order by count(a.number_of_interested_guests) desc
+limit 1;
+}}}