Changes between Initial Version and Version 1 of izvestai

Timestamp:

01/29/25 17:19:04 (9 months ago)

Author:

213209

Comment:

--

izvestai

@@ +1 @@
+= Напредни извештаи од базата (SQL и складирани процедури)
+
+== Извештај за откжани резервации по ресторан. 
+
+{{{
+select
+        count(rh.cancellation_reason),
+    au.first_name, 
+    au.last_name, 
+    au.membership_level, 
+    au."role", 
+    rh.cancellation_reason, 
+    rh.restaurant_id 
+from reservation_history rh  
+inner join app_user au on rh.customer_id = au.id 
+where rh.cancellation_reason = 'Canceled by user'
+group by au.first_name, 
+    au.last_name, 
+    au.membership_level, 
+    au."role", 
+    rh.cancellation_reason, 
+    rh.restaurant_id 
+order by rh.cancellation_reason
+
+select count(r.table_number), r.userid  from reservations r
+group by r.userid  
+}}}