Analytical SQL Views

Description

This section contains SQL views used for reporting and analytical summaries.

1. vw_wedding_financial_summary

Description

Displays wedding budget and total booking expenses.

2. vw_rsvp_overview

Description

Displays RSVP statistics for guests and events.

3. vw_vendor_booking_overview

Description

Displays venue, photographer, and band bookings.

4. vw_upcoming_weddings

Description

Displays upcoming weddings scheduled in the future.

SQL Code

{{collapse(View SQL Code) <syntaxhighlight lang="sql"> PASTE SQL FROM advanced_views.sql </syntaxhighlight> }}