Changes between Version 1 and Version 2 of Analytical SQL Views

Timestamp:

05/12/26 01:57:44 (2 weeks ago)

Author:

193284

Comment:

--

Analytical SQL Views

@@ -11 +11 @@
 Displays wedding budget and total booking expenses.
 
-=== SQL Code ===
-
-{{{
-CREATE OR REPLACE VIEW vw_wedding_financial_summary AS
-SELECT
-    w.wedding_id,
-    w.budget,
-    calculate_wedding_total_cost(w.wedding_id) AS total_cost,
-    w.budget - calculate_wedding_total_cost(w.wedding_id) AS remaining_budget
-FROM wedding w;
-}}}
-
 == 2. vw_rsvp_overview ==
 
@@ -28 +16 @@
 
 Displays RSVP statistics for guests and events.
-
-=== SQL Code ===
-
-{{{
-CREATE OR REPLACE VIEW vw_rsvp_overview AS
-SELECT
-    e.event_id,
-    e.event_type,
-    r.status,
-    COUNT(*) AS total
-FROM event_rsvp r
-JOIN event e ON r.event_id = e.event_id
-GROUP BY e.event_id, e.event_type, r.status;
-}}}
 
 == 3. vw_vendor_booking_overview ==
@@ -49 +23 @@
 Displays venue, photographer, and band bookings.
 
+== 4. vw_upcoming_weddings ==
+
+=== Description ===
+
+Displays upcoming weddings scheduled in the future.
+
 === SQL Code ===
 
-{{{
-CREATE OR REPLACE VIEW vw_vendor_booking_overview AS
-SELECT
-    w.wedding_id,
-    v.name AS venue_name,
-    p.name AS photographer_name,
-    b.band_name
-FROM wedding w
-LEFT JOIN venue_booking vb ON w.wedding_id = vb.wedding_id
-LEFT JOIN venue v ON vb.venue_id = v.venue_id
-LEFT JOIN photographer_booking pb ON w.wedding_id = pb.wedding_id
-LEFT JOIN photographer p ON pb.photographer_id = p.photographer_id
-LEFT JOIN band_booking bb ON w.wedding_id = bb.wedding_id
-LEFT JOIN band b ON bb.band_id = b.band_id;
-}}}
+{{collapse(View SQL Code)
+<syntaxhighlight lang="sql">
+PASTE SQL FROM advanced_views.sql
+</syntaxhighlight>
+}}