By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
ITEM | STOCK_AS_ON_DATE | BUCKET | QUANTITY |
---|---|---|---|
A | 40377 | 1 | 4000 |
A | 40377 | 91 | 4000 |
A | 40377 | 121 | 13000 |
A | 40377 | 271 | 0 |
A | 40377 | 361 | 8340 |
A | 40377 | 451 | 1660 |
A | 40377 | 541 | 8000 |
A | 40377 | 631 | 4400 |
A | 40377 | 721 | 223380 |
B | 48 | 1 | 50 |
B | 48 | 91 | 0 |
B | 48 | 121 | 160 |
B | 48 | 271 | 45 |
B | 48 | 361 | 50 |
B | 48 | 451 | 90 |
B | 48 | 541 | 70 |
B | 48 | 631 | 120 |
B | 48 | 721 | 2913 |
C | 3269 | 1 | 7100 |
C | 3269 | 91 | 6600 |
C | 3269 | 121 | 24100 |
C | 3269 | 271 | 9925 |
C | 3269 | 361 | 0 |
C | 3269 | 451 | 27975 |
C | 3269 | 541 | 23700 |
C | 3269 | 631 | 20000 |
C | 3269 | 721 | 929437 |
D | 3330 | 1 | 3000 |
D | 3330 | 91 | 4400 |
D | 3330 | 121 | 6100 |
D | 3330 | 271 | 1700 |
D | 3330 | 361 | 0 |
D | 3330 | 451 | 10400 |
D | 3330 | 541 | 3000 |
D | 3330 | 631 | 18200 |
D | 3330 | 721 | 628437 |
E | 13225 | 1 | 3000 |
E | 13225 | 91 | 0 |
E | 13225 | 121 | 25100 |
E | 13225 | 271 | 4500 |
E | 13225 | 361 | 4500 |
E | 13225 | 451 | 2900 |
E | 13225 | 541 | 110 |
E | 13225 | 631 | 14800 |
E | 13225 | 721 | 171590 |
F | 1759 | 1 | 526 |
F | 1759 | 91 | 478 |
F | 1759 | 121 | 0 |
F | 1759 | 271 | 0 |
F | 1759 | 361 | 0 |
F | 1759 | 451 | 502 |
F | 1759 | 541 | 484 |
F | 1759 | 631 | 0 |
F | 1759 | 721 | 13308 |
G | 2528 | 1 | 0 |
G | 2528 | 91 | 3500 |
G | 2528 | 121 | 0 |
G | 2528 | 271 | 3500 |
G | 2528 | 361 | 0 |
G | 2528 | 451 | 3000 |
G | 2528 | 541 | 0 |
G | 2528 | 631 | 0 |
G | 2528 | 721 | 43706 |
H | 163 | 1 | 950 |
H | 163 | 91 | 550 |
H | 163 | 121 | 2850 |
H | 163 | 271 | 1480 |
H | 163 | 361 | 735 |
H | 163 | 451 | 2025 |
H | 163 | 541 | 1450 |
H | 163 | 631 | 875 |
H | 163 | 721 | 52278 |
I | 158 | 1 | 520 |
I | 158 | 91 | 200 |
I | 158 | 121 | 914 |
I | 158 | 271 | 350 |
I | 158 | 361 | 420 |
I | 158 | 451 | 540 |
I | 158 | 541 | 300 |
I | 158 | 631 | 150 |
I | 158 | 721 | 10557 |
J | 254 | 1 | 750 |
J | 254 | 91 | 350 |
J | 254 | 121 | 1650 |
J | 254 | 271 | 1050 |
J | 254 | 361 | 570 |
J | 254 | 451 | 1300 |
J | 254 | 541 | 1070 |
J | 254 | 631 | 710 |
J | 254 | 721 | 25886 |
K | 75864 | 1 | 20400 |
K | 75864 | 91 | 0 |
K | 75864 | 121 | 34800 |
K | 75864 | 271 | 32400 |
K | 75864 | 361 | 0 |
K | 75864 | 451 | 32400 |
K | 75864 | 541 | 28800 |
K | 75864 | 631 | 34800 |
K | 75864 | 721 | 701550 |
L | 18074 | 1 | 15525 |
L | 18074 | 91 | 0 |
L | 18074 | 121 | 0 |
L | 18074 | 271 | 41480 |
L | 18074 | 361 | 27630 |
L | 18074 | 451 | 0 |
L | 18074 | 541 | 28850 |
L | 18074 | 631 | 0 |
L | 18074 | 721 | 861545 |
M | 45247 | 1 | 20000 |
M | 45247 | 91 | 0 |
M | 45247 | 121 | 0 |
M | 45247 | 271 | 35000 |
M | 45247 | 361 | 60000 |
M | 45247 | 451 | 0 |
M | 45247 | 541 | 0 |
M | 45247 | 631 | 0 |
M | 45247 | 721 | 834240 |
N | 3332 | 1 | 4125 |
N | 3332 | 91 | 0 |
N | 3332 | 121 | 5625 |
N | 3332 | 271 | 2690 |
N | 3332 | 361 | 3015 |
N | 3332 | 451 | 2035 |
N | 3332 | 541 | 3380 |
N | 3332 | 631 | 5290 |
N | 3332 | 721 | 152709 |
O | 287 | 1 | 522 |
O | 287 | 91 | 132 |
O | 287 | 121 | 1878 |
O | 287 | 271 | 864 |
O | 287 | 361 | 66 |
O | 287 | 451 | 725 |
O | 287 | 541 | 795 |
O | 287 | 631 | 852 |
O | 287 | 721 | 36503 |
P | 338 | 1 | 401 |
P | 338 | 91 | 134 |
P | 338 | 121 | 1113 |
P | 338 | 271 | 484 |
P | 338 | 361 | 127 |
P | 338 | 451 | 627 |
P | 338 | 541 | 745 |
P | 338 | 631 | 813 |
P | 338 | 721 | 18715 |
Q | 892 | 1 | 650 |
Q | 892 | 91 | 1000 |
Q | 892 | 121 | 3200 |
Q | 892 | 271 | 1800 |
Q | 892 | 361 | 0 |
Q | 892 | 451 | 3400 |
Q | 892 | 541 | 3600 |
Q | 892 | 631 | 2200 |
Q | 892 | 721 | 113347 |
ITEM | STOCK_AS_ON_DATE | BUCKET | QUANTITY |
---|---|---|---|
A | 40377 | 1 | 4000 |
A | 40377 | 91 | 4000 |
A | 40377 | 121 | 13000 |
A | 40377 | 271 | 0 |
A | 40377 | 361 | 8340 |
A | 40377 | 451 | 1660 |
A | 40377 | 541 | 8000 |
A | 40377 | 631 | 1377 |
A | 40377 | 721 | 0 |
B | 48 | 1 | 48 |
B | 48 | 91 | 0 |
B | 48 | 121 | 0 |
B | 48 | 271 | 0 |
B | 48 | 361 | 0 |
B | 48 | 451 | 0 |
B | 48 | 541 | 0 |
B | 48 | 631 | 0 |
B | 48 | 721 | 0 |
C | 3269 | 1 | 3269 |
C | 3269 | 91 | 0 |
C | 3269 | 121 | 0 |
C | 3269 | 271 | 0 |
C | 3269 | 361 | 0 |
C | 3269 | 451 | 0 |
C | 3269 | 541 | 0 |
C | 3269 | 631 | 0 |
C | 3269 | 721 | 0 |
D | 3330 | 1 | 3000 |
D | 3330 | 91 | 330 |
D | 3330 | 121 | 0 |
D | 3330 | 271 | 0 |
D | 3330 | 361 | 0 |
D | 3330 | 451 | 0 |
D | 3330 | 541 | 0 |
D | 3330 | 631 | 0 |
D | 3330 | 721 | 0 |
E | 13225 | 1 | 3000 |
E | 13225 | 91 | 0 |
E | 13225 | 121 | 10225 |
E | 13225 | 271 | 0 |
E | 13225 | 361 | 0 |
E | 13225 | 451 | 0 |
E | 13225 | 541 | 0 |
E | 13225 | 631 | 0 |
E | 13225 | 721 | 0 |
F | 1759 | 1 | 526 |
F | 1759 | 91 | 478 |
F | 1759 | 121 | 0 |
F | 1759 | 271 | 0 |
F | 1759 | 361 | 0 |
F | 1759 | 451 | 502 |
F | 1759 | 541 | 253 |
F | 1759 | 631 | 0 |
F | 1759 | 721 | 0 |
G | 2528 | 1 | 0 |
G | 2528 | 91 | 2528 |
G | 2528 | 121 | 0 |
G | 2528 | 271 | 0 |
G | 2528 | 361 | 0 |
G | 2528 | 451 | 0 |
G | 2528 | 541 | 0 |
G | 2528 | 631 | 0 |
G | 2528 | 721 | 0 |
H | 163 | 1 | 163 |
H | 163 | 91 | 0 |
H | 163 | 121 | 0 |
H | 163 | 271 | 0 |
H | 163 | 361 | 0 |
H | 163 | 451 | 0 |
H | 163 | 541 | 0 |
H | 163 | 631 | 0 |
H | 163 | 721 | 0 |
I | 158 | 1 | 158 |
I | 158 | 91 | 0 |
I | 158 | 121 | 0 |
I | 158 | 271 | 0 |
I | 158 | 361 | 0 |
I | 158 | 451 | 0 |
I | 158 | 541 | 0 |
I | 158 | 631 | 0 |
I | 158 | 721 | 0 |
J | 254 | 1 | 254 |
J | 254 | 91 | 0 |
J | 254 | 121 | 0 |
J | 254 | 271 | 0 |
J | 254 | 361 | 0 |
J | 254 | 451 | 0 |
J | 254 | 541 | 0 |
J | 254 | 631 | 0 |
J | 254 | 721 | 0 |
K | 75864 | 1 | 20400 |
K | 75864 | 91 | 0 |
K | 75864 | 121 | 34800 |
K | 75864 | 271 | 20664 |
K | 75864 | 361 | 0 |
K | 75864 | 451 | 0 |
K | 75864 | 541 | 0 |
K | 75864 | 631 | 0 |
K | 75864 | 721 | 0 |
L | 18074 | 1 | 15525 |
L | 18074 | 91 | 0 |
L | 18074 | 121 | 0 |
L | 18074 | 271 | 2549 |
L | 18074 | 361 | 0 |
L | 18074 | 451 | 0 |
L | 18074 | 541 | 0 |
L | 18074 | 631 | 0 |
L | 18074 | 721 | 0 |
M | 45247 | 1 | 20000 |
M | 45247 | 91 | 0 |
M | 45247 | 121 | 0 |
M | 45247 | 271 | 25247 |
M | 45247 | 361 | 0 |
M | 45247 | 451 | 0 |
M | 45247 | 541 | 0 |
M | 45247 | 631 | 0 |
M | 45247 | 721 | 0 |
N | 3332 | 1 | 3332 |
N | 3332 | 91 | 0 |
N | 3332 | 121 | 0 |
N | 3332 | 271 | 0 |
N | 3332 | 361 | 0 |
N | 3332 | 451 | 0 |
N | 3332 | 541 | 0 |
N | 3332 | 631 | 0 |
N | 3332 | 721 | 0 |
O | 287 | 1 | 287 |
O | 287 | 91 | 0 |
O | 287 | 121 | 0 |
O | 287 | 271 | 0 |
O | 287 | 361 | 0 |
O | 287 | 451 | 0 |
O | 287 | 541 | 0 |
O | 287 | 631 | 0 |
O | 287 | 721 | 0 |
P | 338 | 1 | 338 |
P | 338 | 91 | 0 |
P | 338 | 121 | 0 |
P | 338 | 271 | 0 |
P | 338 | 361 | 0 |
P | 338 | 451 | 0 |
P | 338 | 541 | 0 |
P | 338 | 631 | 0 |
P | 338 | 721 | 0 |
Q | 892 | 1 | 650 |
Q | 892 | 91 | 242 |
Q | 892 | 121 | 0 |
Q | 892 | 271 | 0 |
Q | 892 | 361 | 0 |
Q | 892 | 451 | 0 |
Q | 892 | 541 | 0 |
Q | 892 | 631 | 0 |
Q | 892 | 721 | 0 |
ITEM | STOCK_AS_ON_DATE | A1TO90 | A91TO120 | A121TO270 | A271TO360 | A361TO450 | A451TO540 | A541TO630 | A631TO720 | A721PLUS |
---|---|---|---|---|---|---|---|---|---|---|
A | 40377 | 4000 | 4000 | 13000 | 0 | 8340 | 1660 | 8000 | 1377 | 0 |
B | 48 | 48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
C | 3269 | 3269 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
D | 3330 | 3000 | 330 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
E | 13225 | 3000 | 0 | 10225 | 0 | 0 | 0 | 0 | 0 | 0 |
F | 1759 | 526 | 478 | 0 | 0 | 0 | 502 | 253 | 0 | 0 |
G | 2528 | 0 | 2528 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
H | 163 | 163 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
I | 158 | 158 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
J | 254 | 254 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
K | 75864 | 20400 | 0 | 34800 | 20664 | 0 | 0 | 0 | 0 | 0 |
L | 18074 | 15525 | 0 | 0 | 2549 | 0 | 0 | 0 | 0 | 0 |
M | 45247 | 20000 | 0 | 0 | 25247 | 0 | 0 | 0 | 0 | 0 |
N | 3332 | 3332 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
O | 287 | 287 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
P | 338 | 338 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Q | 892 | 650 | 242 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
ITEM | STOCK_AS_ON_DATE | A1TO90 | A91TO120 | A121TO270 | A271TO360 | A361TO450 | A451TO540 | A541TO630 | A631TO720 | A721PLUS | TOTAL |
---|---|---|---|---|---|---|---|---|---|---|---|
A | 40377 | 4000 | 4000 | 13000 | 0 | 8340 | 1660 | 8000 | 1377 | 0 | 40377 |
B | 48 | 48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 48 |
C | 3269 | 3269 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3269 |
D | 3330 | 3000 | 330 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3330 |
E | 13225 | 3000 | 0 | 10225 | 0 | 0 | 0 | 0 | 0 | 0 | 13225 |
F | 1759 | 526 | 478 | 0 | 0 | 0 | 502 | 253 | 0 | 0 | 1759 |
G | 2528 | 0 | 2528 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2528 |
H | 163 | 163 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 163 |
I | 158 | 158 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 158 |
J | 254 | 254 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 254 |
K | 75864 | 20400 | 0 | 34800 | 20664 | 0 | 0 | 0 | 0 | 0 | 75864 |
L | 18074 | 15525 | 0 | 0 | 2549 | 0 | 0 | 0 | 0 | 0 | 18074 |
M | 45247 | 20000 | 0 | 0 | 25247 | 0 | 0 | 0 | 0 | 0 | 45247 |
N | 3332 | 3332 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3332 |
O | 287 | 287 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 287 |
P | 338 | 338 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 338 |
Q | 892 | 650 | 242 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 892 |