By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
BusinessRefId | Period | GoalType | Amount | StartDateUtc | EndDateUtc | Currency |
---|---|---|---|---|---|---|
Business A | 2019-2020 | CommittedTransactionFee | 45000.0000 | 2019-07-06 00:00:00.000 | 2020-07-06 00:00:00.000 | USD |
Business A | 2020-2021 | CommittedTransactionFee | 45000.0000 | 2020-07-06 00:00:00.000 | 2021-07-06 00:00:00.000 | USD |
Business A | 2021-2022 | CommittedTransactionFee | 45000.0000 | 2021-07-06 00:00:00.000 | 2022-07-06 00:00:00.000 | USD |
Business B | 2017-2018 | CommittedTransactionFee | 18000.0000 | 2017-07-06 00:00:00.000 | 2018-07-06 00:00:00.000 | USD |
Business B | 2018-2019 | CommittedTransactionFee | 18000.0000 | 2018-07-06 00:00:00.000 | 2019-07-06 00:00:00.000 | USD |
Business B | 2019-2020 | CommittedTransactionFee | 18000.0000 | 2019-07-06 00:00:00.000 | 2020-07-06 00:00:00.000 | USD |
Business C | 2016-2017 | CommittedTransactionFee | 3000.0000 | 2016-02-14 00:00:00.000 | 2017-02-14 00:00:00.000 | USD |
Business C | 2017-2018 | CommittedTransactionFee | 3000.0000 | 2017-02-14 00:00:00.000 | 2018-01-05 00:00:00.000 | USD |