Changes between Version 3 and Version 4 of Analytical SQL Views
- Timestamp:
- 05/13/26 19:59:04 (13 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Analytical SQL Views
v3 v4 13 13 === SQL Code === 14 14 15 <pre> 15 {{{ 16 #!sql 16 17 CREATE OR REPLACE VIEW vw_wedding_financial_summary AS 17 18 SELECT … … 21 22 w.budget - calculate_wedding_total_cost(w.wedding_id) AS remaining_budget 22 23 FROM wedding w; 23 </pre> 24 }}} 24 25 25 26 == 2. vw_rsvp_overview == … … 31 32 === SQL Code === 32 33 33 <pre> 34 {{{ 35 #!sql 34 36 CREATE OR REPLACE VIEW vw_rsvp_overview AS 35 37 SELECT … … 41 43 JOIN event e ON r.event_id = e.event_id 42 44 GROUP BY e.event_id, e.event_type, r.status; 43 </pre> 45 }}} 44 46 45 47 == 3. vw_vendor_booking_overview == … … 51 53 === SQL Code === 52 54 53 <pre> 55 {{{ 56 #!sql 54 57 CREATE OR REPLACE VIEW vw_vendor_booking_overview AS 55 58 SELECT … … 65 68 LEFT JOIN band_booking bb ON w.wedding_id = bb.wedding_id 66 69 LEFT JOIN band b ON bb.band_id = b.band_id; 67 </pre> 70 }}} 68 71 69 72 == 4. vw_upcoming_weddings == … … 75 78 === SQL Code === 76 79 77 <pre> 80 {{{ 81 #!sql 78 82 CREATE OR REPLACE VIEW vw_upcoming_weddings AS 79 83 SELECT 80 84 wedding_id, 81 wedding_date,85 "date" AS wedding_date, 82 86 budget, 83 status87 notes 84 88 FROM wedding 85 WHERE wedding_date>= CURRENT_DATE;86 </pre> 89 WHERE "date" >= CURRENT_DATE; 90 }}}
