I don't know if I'm using the correct terminology, but I'm trying to find the cumulative sum of each node in a tree structure, but the children node only contribute a percentage of its cumulative sum to its parent node's…
I've a Postgres table like this where a order count for each tenant is inserted when it changes. datetime tenant_id orders 2023-09-15 22:00 tenant3 2 2023-09-16 01:00 tenant1 2 2023-09-16 02:00 tenant1 3 2023-09-16 02:00 tenant2 5 2023-09-16 03:00 tenant1…
I have two tables Customers customer customer_name 1 Headley Quincey 2 Andie Smith 3 Sarah Johnson 4 Ernest Forrest Payments payment_id date customer sum_payment 1 2010-01-02 2 200 2 2011-06-06 3 500 3 2020-01-01 1 700 4 2020-02-01 1 100…
I have a repayment table that looks like this below, cus_id due_date principal disbursed_date 1 01-01-2022 10 01-11-2021 1 01-02-2022 10 01-11-2021 1 01-03-2022 10 01-11-2021 2 15-03-2022 20 15-02-2022 1 01-04-2022 10 01-11-2021 3 01-04-2022 15 20-03-2022 2 15-04-2022…