By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
14 rows affected
| CustomerName | CustomerTypeDisplayName | NumberOfOrders | EarliestOrderDate |
|---|---|---|---|
| Janet Peters | Individual | 2 | 2010-01-02 |
| John Smith | Individual | 2 | 2010-01-01 |
| Paul Taylor | Individual | 0 | null |
| Peterson Ltd | Organisation | 4 | 2010-01-02 |
Warning: Null value is eliminated by an aggregate or other SET operation.