Changes between Version 4 and Version 5 of izvestai

Timestamp:

01/29/25 20:32:05 (27 hours ago)

Author:

213209

Comment:

--

izvestai

@@ -31 +31 @@
 
 ORDER BY canceled_by_user_per_restaurant DESC;}}}
+
+
+== Извештај за најмногу резервации по ресторан
+
+{{{
+SELECT r.restaurantId, r."name", COUNT(res.reservationId) AS totalReservations
+FROM restaurants r
+JOIN reservations res ON r.restaurantId = res.restaurantId
+GROUP BY r.restaurantId, r."name" 
+ORDER BY totalReservations desc
+}}}