Changes between Version 9 and Version 10 of izvestai

Timestamp:

01/29/25 21:00:19 (27 hours ago)

Author:

213209

Comment:

--

izvestai

@@ -46 +46 @@
     ROUND(AVG(rh.party_size), 1) AS average_party_size,
     MAX(rh.party_size) AS max_party_size,
-    COUNT(*) AS number_of_reservations
+    COUNT(rh.id) AS number_of_reservations
 FROM reservation_history rh 
 JOIN "tables" t ON t.tableid = rh.table_id  
@@ -55 +55 @@
 }}}
 
+== Извештај за најрезервиран временски период во ресторан
+{{{
+SELECT 
+    r."name",
+    CONCAT(
+        LPAD(DATE_PART('hour', rh.check_in_date)::TEXT, 2, '0'), 
+        ':00 - ', 
+        LPAD((DATE_PART('hour', rh.check_in_date) + 2)::TEXT, 2, '0'),
+        ':00'
+    ) AS hour_slot, 
+    COUNT(rh.id) AS totalReservations
+FROM reservation_history rh 
+JOIN restaurants r ON rh.restaurant_id = r.restaurantid
+GROUP BY hour_slot, r."name" 
+ORDER BY totalReservations DESC, r."name"  
+LIMIT 5;
+}}}