Changes between Version 7 and Version 8 of izvestai

Timestamp:

01/29/25 20:48:23 (27 hours ago)

Author:

213209

Comment:

--

izvestai

@@ -10 +10 @@
     au."role", 
     rh.restaurant_id,
-    
     COUNT(CASE WHEN rh.cancellation_reason = 'Canceled by user' THEN 1 END) AS canceled_by_user_per_restaurant,
-
     COUNT(CASE WHEN rh.cancellation_reason = '/' THEN 1 END) AS succesfull_by_user_per_restaurant,
-
     COUNT(rh.cancellation_reason) AS total_cancellations_per_restaurant
-
 FROM reservation_history rh  
 INNER JOIN app_user au ON rh.customer_id = au.id 
-
 WHERE rh.cancellation_reason IS NOT NULL  
-
 GROUP BY au.first_name, 
          au.last_name, 
@@ -41 +35 @@
 FROM restaurants r
 JOIN reservations res ON r.restaurantId = res.restaurantId
-GROUP BY r.restaurantId, r."name" 
+GROUP BY r.restaurantId, 
+         r."name" 
 ORDER BY totalReservations desc
 }}}