By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
14 rows affected
| HouseID | FinalName | EventType | EventDate |
|---|---|---|---|
| 1 | Will Stanton | Birthday | 1974-01-05 |
| 1 | Mary Stanton | Birthday | 1980-05-22 |
| 2 | Jason Stockmore Stockmore | Birthday | 1987-12-07 |
| 3 | Mark Mellony and Stacy Mellony | Wedding | 2021-04-04 |
| 4 | Stephen Johnson and Janetsy Johnson | Wedding | 2012-01-30 |
| 5 | George Jackson and Sally Mistmoore | Wedding | 2009-11-15 |
| 6 | Sandy Katz | Wedding | 2010-03-19 |
| 6 | Jeff Trilov | Wedding | 2016-09-09 |
| 7 | Sandra Kirchbaum Kirchbaum | Wedding | 2011-05-22 |
| 8 | Frank Fjorn | Birthday | 1969-07-19 |
| 8 | Jessica Bower | Birthday | 1996-02-26 |
Warning: Null value is eliminated by an aggregate or other SET operation.