Moving day wise window, sum calculation for different days

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.

Compétences : SQL, MySQL, Redshift

en voir plus : beta calculation days, moving dotproject application different server, moving website host day, sql rolling window, window sum tableau, sql sum over date range, tableau moving average without table calculation, tableau moving average calculated field, tableau window_avg, sql rolling 30 days, sql rolling sum by date, sum days application excel, moving website different hosting, days calculation applet, acrobat javascript calculation days, visual basic apr calculation odd days, bring moving average chart window mt4, jquery sum calculation, acrobat javascript date calculation add days, drupal sum calculation

Concernant l'employeur :
( 0 commentaires ) Athlone, Ireland

Nº du projet : #26809488

5 freelance font une offre moyenne de €7/heure pour ce travail


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 Plus

€10 EUR / heure
(4 Commentaires)

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 Plus

€5 EUR / heure
(1 Évaluation)

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 / heure
(0 Commentaires)

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 Plus

€11 EUR / heure
(0 Commentaires)

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 / heure
(0 Commentaires)