Est. Budget: $25.00
1- New SQL SCRIPT to have the interval 1 to 9
you have the last_date_out but what I want is the 9 other date that this number came out and the interval between each one
and after, I want the avg_gap_int_days and days_left_avg_int_gap_days of the interval 1 to 9
Formula for avg_gap_int_days = (int1 + int2 + int3 + int4 + int5 + int6 + int7 + int8 + int9) / 9
Formula for days_left_avg_int_gap_days = avg_gap_int_days - day_now
2- I will want the same script ...