By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | date | amount | currency | product |
---|---|---|---|---|
1 | 2021-04-22 | 12 | USD | Salmon |
2 | 2021-04-27 | 4.75 | EUR | beer |
result |
---|
{"2021-04-22": [{"id": 1, "date": "2021-04-22", "amount": 12.0, "product": "Salmon", "currency": "USD"}], "2021-04-27": [{"id": 2, "date": "2021-04-27", "amount": 4.75, "product": "beer", "currency": "EUR"}]} |