By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
15 rows affected
ccp | years | quart | q1 |
---|---|---|---|
CCP1 | 2015 | 1 | 18.000000 |
CCP1 | 2015 | 2 | 8.000000 |
CCP1 | 2015 | 3 | 6.000000 |
CCP1 | 2015 | 4 | 9.000000 |
CCP1 | 2016 | 1 | 12.000000 |
ccp | years | quart | q2 |
---|---|---|---|
CCP1 | 2015 | 1 | 1 |
CCP1 | 2015 | 2 | 18 |
CCP1 | 2015 | 3 | 144 |
CCP1 | 2015 | 4 | 864 |
CCP1 | 2016 | 1 | 7776 |
CCP | months | QUART | YEARS | GTS | result | baseline |
---|---|---|---|---|---|---|
CCP1 | 1 | 1 | 2015 | 5.000000 | 25.000000 | 5.000000 |
CCP1 | 2 | 1 | 2015 | 6.000000 | 30.000000 | 5.000000 |
CCP1 | 3 | 1 | 2015 | 7.000000 | 35.000000 | 5.000000 |
CCP1 | 4 | 2 | 2015 | 4.000000 | 360.000000 | 90.000000 |
CCP1 | 5 | 2 | 2015 | 2.000000 | 180.000000 | 90.000000 |
CCP1 | 6 | 2 | 2015 | 2.000000 | 180.000000 | 90.000000 |
CCP1 | 7 | 3 | 2015 | 3.000000 | 2160.000000 | 720.000000 |
CCP1 | 8 | 3 | 2015 | 2.000000 | 1440.000000 | 720.000000 |
CCP1 | 9 | 3 | 2015 | 1.000000 | 720.000000 | 720.000000 |
CCP1 | 10 | 4 | 2015 | 2.000000 | 8640.000000 | 4320.000000 |
CCP1 | 11 | 4 | 2015 | 3.000000 | 12960.000000 | 4320.000000 |
CCP1 | 12 | 4 | 2015 | 4.000000 | 17280.000000 | 4320.000000 |
CCP1 | 1 | 1 | 2016 | 8.000000 | 311040.000000 | 38880.000000 |
CCP1 | 2 | 1 | 2016 | 1.000000 | 38880.000000 | 38880.000000 |
CCP1 | 3 | 1 | 2016 | 3.000000 | 116640.000000 | 38880.000000 |