Changes between Version 2 and Version 3 of Напредни извештаи од базата (SQL и складирани процедури)

Timestamp:

02/06/25 14:07:59 (2 weeks ago)

Author:

173067

Comment:

--

Напредни извештаи од базата (SQL и складирани процедури)

@@ -223 +223 @@
 {{{
 WITH MonthlyBookings AS (
-    -- Count bookings for each destination per month
     SELECT 
         DATE_TRUNC('month', b.bookingDate) AS month,
@@ -237 +236 @@
 
 MonthlyFlights AS (
-    -- Count bookings for each flight per month
     SELECT 
         DATE_TRUNC('month', b.bookingDate) AS month,
@@ -249 +247 @@
 
 MonthlyAirports AS (
-    -- Count departures from each airport per month
     SELECT 
         DATE_TRUNC('month', b.bookingDate) AS month,
@@ -261 +258 @@
 )
 
--- Retrieve the top 3 destinations, flights, and airports for each month
 SELECT month, 'Destination' AS category, destination_name AS name, bookings_count AS count FROM MonthlyBookings WHERE rank <= 3
 UNION ALL