Moving day wise window, sum calculation for different days

ปิด โพสต์แล้ว 3 ปีที่ผ่านมา ชำระเงินเมื่อจัดส่ง
ปิด

I need some help in my sql stuck with some project where i need to make a sliding ,moving window of sum of different amounts of money(threshold set for all days) in last 1,20, 40 and 150 days. The one with 40 days is slightly on a different filter. This window checks if transaction is beyond a certain amount in these days then some documents are needed. All data is arranged in tables.

Second query relates to first in a way that if highlighted in first case then it needs to be checked if documents were provided in next 10 days.

I have done the first query using sub queries but i am stuck in last part of first one where i need to use some more conditions for 40 days and cannot include it in the same set of sub query.

Do let me know i need urgent help.Thanks.

SQL MySQL เรดชิฟ

หมายเลขโปรเจค: #26809488

เกี่ยวกับโปรเจกต์

5 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

freelancer freelancer 5 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ €7/ชั่วโมง

fadeevdoma

Hello, I am SQL expert and good in Mysqlm, MSsql, MariaDB... for DDL, DML queries, procedures, DB design and management.. SO I can fix your issue easily and quickly. Please contact to me to have fast and good result. T เพิ่มเติม

€10 EUR / ชั่วโมง
(4 รีวิว)
2.4
lazrodrigue

I have read your project description in detail and it seems just like that you posted this for me. I have 10 years of IT programming. My Technical background Database/Datawarehouse - SQL Server, Oracle, MySQL, Postgre เพิ่มเติม

€5 EUR / ชั่วโมง
(1 รีวิว)
1.5
ankitrajbhakt

i am expert in SQL just because i am student of IT i have done my work with 100% Satisfaction i am waiting.....

€6 EUR / ชั่วโมง
(0 รีวิว)
0.0
rashmi116

I have 6. + years working experience in USA and Canada in Sql, ssis, ssrs and Power BI . Expert in Sql querying . We can use case statements like IF conditions in the query and then select . I would like to help y เพิ่มเติม

€11 EUR / ชั่วโมง
(0 รีวิว)
0.0
Magesh513

Hi, I am proficient in Sql and certified in SQL Querying 70-461. If you need urgent help I can do it. Please contact me for discussion about your project.

€4 EUR / ชั่วโมง
(0 รีวิว)
0.0