Hi-Need assistance to populate the column avg_days using sql.
For a quarter for a particular Mat_no we need to calculate the avg of dl and the calculated avg dl need to be populated in the column avg_days against the same material in the next quarter.
If the Material number is not present in the previous quarter then populate in the current quarter as null under the column avg_days
Thanks in advance.
| mat_no | del_date | dl | avg_days |
|---|
| M01 | 1/2/2019 | 15 | |
| M01 | 1/12/2019 | 14 | |
| M01 | 1/16/2019 | 12 | |
| M01 | 1/19/2019 | 12 | |
| M01 | 2/24/2019 | 10 | |
| M02 | 1/4/2019 | 5 | |
| M02 | 1/11/2019 | 7 | |
| M02 | 1/15/2019 | 8 | |
| M02 | 1/17/2019 | 6 | |
| M02 | 2/25/2019 | 8 | |
| M03 | 1/5/2019 | 12 | |
| M03 | 1/9/2019 | 15 | |
| M03 | 1/14/2019 | 11 | |
| M03 | 1/20/2019 | 14 | |
| M03 | 3/27/2019 | 9 | |
| M04 | 1/8/2019 | 14 | |
| M04 | 1/12/2019 | 12 | |
| M04 | 1/16/2019 | 11 | |
| M04 | 1/21/2019 | 10 | |
| M04 | 2/28/2019 | 16 | |
| | | |
| M01 | 4/2/2019 | 16 | 12.6 |
| M01 | 4/12/2019 | 14 | 12.6 |
| M01 | 4/16/2019 | 12 | 12.6 |
| M01 | 4/19/2019 | 12 | 12.6 |
| M01 | 5/24/2019 | 10 | 12.6 |
| M02 | 4/4/2019 | 5 | 6.8 |
| M02 | 4/11/2019 | 7 | 6.8 |
| M02 | 4/15/2019 | 8 | 6.8 |
| M02 | 4/17/2019 | 6 | 6.8 |
| M02 | 5/25/2019 | 9 | 6.8 |
| M03 | 4/5/2019 | 12 | 12.2 |
| M03 | 4/9/2019 | 15 | 12.2 |
| M03 | 4/14/2019 | 11 | 12.2 |
| M03 | 4/20/2019 | 14 | 12.2 |
| M03 | 6/27/2019 | 9 | 12.2 |
| M05 | 4/8/2019 | 14 | |
| M05 | 4/12/2019 | 12 | |
| M05 | 4/16/2019 | 11 | |
| M05 | 4/21/2019 | 10 | |
| M05 | 5/28/2019 | 16 | |
| | | |
| M01 | 7/2/2019 | 15 | 12.8 |
| M01 | 7/12/2019 | 14 | 12.8 |
| M01 | 7/16/2019 | 12 | 12.8 |
| M01 | 7/19/2019 | 12 | 12.8 |
| M01 | 8/24/2019 | 8 | 12.8 |
| M02 | 7/4/2019 | 5 | 7 |
| M02 | 7/11/2019 | 7 | 7 |
| M02 | 7/15/2019 | 8 | 7 |
| M02 | 7/17/2019 | 9 | 7 |
| M02 | 8/25/2019 | 8 | 7 |
| M04 | 7/5/2019 | 12 | |
| M04 | 7/9/2019 | 15 | |
| M04 | 7/14/2019 | 11 | |
| M04 | 7/20/2019 | 14 | |
| M04 | 8/27/2019 | 10 | |
| M05 | 7/8/2019 | 14 | 12.6 |
| M05 | 7/12/2019 | 12 | 12.6 |
| M05 | 7/16/2019 | 11 | 12.6 |
| M05 | 7/21/2019 | 10 | 12.6 |
| M05 | 8/28/2019 | 16 | 12.6 |
| | | |
| M01 | 10/2/2019 | 15 | 12.2 |
| M01 | 10/12/2019 | 14 | 12.2 |
| M01 | 10/16/2019 | 12 | 12.2 |
| M01 | 10/19/2019 | 12 | 12.2 |
| M01 | 11/24/2019 | 10 | 12.2 |
| M02 | 10/4/2019 | 5 | 7.4 |
| M02 | 10/11/2019 | 7 | 7.4 |
| M02 | 10/15/2019 | 8 | 7.4 |
| M02 | 10/17/2019 | 6 | 7.4 |
| M02 | 11/25/2019 | 8 | 7.4 |
| M04 | 10/5/2019 | 12 |
|