= Stored Functions and Procedures =

== Description ==

This section contains reusable SQL functions and procedures used for calculations, validation, and reporting.

== 1. calculate_wedding_total_cost() ==

=== Description ===

Calculates the total cost of a wedding using venue, photographer, and band bookings.

== 2. is_venue_available() ==

=== Description ===

Checks whether a venue is available for a selected date and time interval.

== 3. is_photographer_available() ==

=== Description ===

Checks whether a photographer is available for a selected date and time interval.

== 4. generate_rsvp_summary() ==

=== Description ===

Returns RSVP statistics for a selected event.

=== SQL Code ===

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