Changes between Version 8 and Version 9 of Advanced database reports (SQL and Stored procedures)

Timestamp:

12/28/22 16:45:40 (2 years ago)

Author:

201101

Comment:

--

Advanced database reports (SQL and Stored procedures)

@@ -138 +138 @@
 == Преглед на бројот на резервации по категории за секој корисник
 
-select ut.full_name ,
-       (
+{{{#!sql
+   select  ut.full_name,
+           (
                 select  count(rfa.reservation_id)
                 from reservation_for_activity rfa
-       )as number_reservations_for_activity,
+           )as number_reservations_for_activity,
            (
-                        select count(rfe.reservation_id)
-                        from reservation_for_events rfe
+                select count(rfe.reservation_id)
+                from reservation_for_events rfe
            )as number_reservations_for_events,
            (
-                        select count(rfpm.reservation_id)
-                        from reservation_for_prepared_meal rfpm 
+                select count(rfpm.reservation_id)
+                from reservation_for_prepared_meal rfpm 
            )as number_reservations_for_meal,
            (
-                        select count(rfs.reservation_id)
-                        from reservation_for_service rfs 
+                select count(rfs.reservation_id)
+                from reservation_for_service rfs 
            )as number_reservations_for_service
 from user_table ut
@@ -163 +164 @@
 on gmr.reservation_id = r.reservation_id
 group by 1;
-
-
+}}}