By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
cName | Address | Restaurant | fName | mName | dDate |
---|---|---|---|---|---|
Bill | 123 1st St | McDs | Bacon & Egg Biscut | 1 - Breakfast | 11/01/2020 |
Bill | 123 1st St | McDs | Happy Meal | 2 - Lunch | 11/01/2020 |
Bill | 123 1st St | Dominos | Pizza | 3 - Dinner | 11/01/2020 |
Fred | 111 Market St | McDs | Bacon & Egg Biscut | 1 - Breakfast | 11/01/2020 |
Fred | 111 Market St | McDs | Happy Meal | 2 - Lunch | 11/01/2020 |
Fred | 111 Market St | Dominos | Pizza | 3 - Dinner | 11/01/2020 |
Lisa | 01 Boulevard | McDs | Bacon & Egg Biscut | 1 - Breakfast | 11/01/2020 |
Lisa | 01 Boulevard | GrubHub | Santa Fe Salad | 2 - Lunch | 11/01/2020 |
Lisa | 01 Boulevard | Dominos | Pizza | 3 - Dinner | null |
Warning: Null value is eliminated by an aggregate or other SET operation.