SELECT * FROM `tmp_v_lis_indihome_3p_new2`
Filter rows: |
CWITEL | PERIODE | MTD | SALES | SALES_FTTH | CHURN | CHURN_FTTH | LIS | FTTH | |
---|---|---|---|---|---|---|---|---|---|
40 | 20211116 | 202111 | 10 | 10 | 6 | 5 | 4 | 5 | |
46 | 20190621 | 201906 | NULL | NULL | 9 | 5 | -9 | -5 | |
39 | 20211116 | 202111 | 38 | 38 | 22 | 6 | 16 | 32 | |
20 | 20200130 | 202001 | NULL | NULL | 33 | 32 | -33 | -32 | |
56 | 20211116 | 202111 | 9 | 8 | 12 | 11 | -3 | -3 | |
38 | 20211116 | 202111 | 14 | 14 | 9 | 4 | 5 | 10 | |
17 | 20211116 | 202111 | 28 | 26 | 2 | 2 | 26 | 24 | |
39 | 20200130 | 202001 | NULL | NULL | 63 | 22 | -63 | -22 | |
56 | 20200130 | 202001 | NULL | NULL | 10 | 3 | -10 | -3 | |
20 | 20170108 | 201701 | NULL | NULL | 1 | 0 | -1 | 0 | |
20 | 20190621 | 201906 | NULL | NULL | 25 | 20 | -25 | -20 | |
16 | 20190621 | 201906 | NULL | NULL | 2 | 1 | -2 | -1 | |
33 | 20170108 | 201701 | NULL | NULL | 2 | 0 | -2 | 0 | |
4 | 20200130 | 202001 | NULL | NULL | 18 | 16 | -18 | -16 | |
24 | 20211116 | 202111 | 13 | 13 | 4 | 4 | 9 | 9 | |
5 | 20211116 | 202111 | 45 | 45 | 22 | 16 | 23 | 29 | |
32 | 20211116 | 202111 | 27 | 26 | 21 | 16 | 6 | 10 | |
63 | 20220916 | 202209 | NULL | NULL | 3 | 1 | -3 | -1 | |
35 | 20170108 | 201701 | NULL | NULL | 1 | 1 | -1 | -1 | |
63 | 20190621 | 201906 | NULL | NULL | 4 | 3 | -4 | -3 | |
56 | 20190621 | 201906 | NULL | NULL | 14 | 10 | -14 | -10 | |
3 | 20190621 | 201906 | NULL | NULL | 6 | 4 | -6 | -4 | |
12 | 20190621 | 201906 | NULL | NULL | 13 | 8 | -13 | -8 | |
26 | 20200130 | 202001 | NULL | NULL | 16 | 13 | -16 | -13 | |
41 | 20211116 | 202111 | 12 | 12 | 5 | 5 | 7 | 7 |
Filter rows: |