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

Timestamp:

12/28/22 16:44:33 (2 years ago)

Author:

201101

Comment:

--

Advanced database reports (SQL and Stored procedures)

@@ -136 +136 @@
 }}}
 
-== Преглед на вкупниот број резервации кои ги има направено секој од корисниците
+== Преглед на бројот на резервации по категории за секој корисник
 
-{{{#!sql
-select ut.full_name , sum(gmr.reservation_id) as number_reservations
+select ut.full_name ,
+       (
+                select  count(rfa.reservation_id)
+                from reservation_for_activity rfa
+       )as number_reservations_for_activity,
+           (
+                        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 
+           )as number_reservations_for_meal,
+           (
+                        select count(rfs.reservation_id)
+                        from reservation_for_service rfs 
+           )as number_reservations_for_service
 from user_table ut
 join guests g 
@@ -148 +163 @@
 on gmr.reservation_id = r.reservation_id
 group by 1;
-}}}
+
+
+
 
 == Број на соби во секоја вила