By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
| ID | COLUMN_VALUE | CNT |
|---|---|---|
| A | 1 | 12 |
| A | 2 | 12 |
| A | 3 | 12 |
| A | 4 | 12 |
| A | 5 | 12 |
| A | 6 | 12 |
| A | 7 | 12 |
| A | 8 | 12 |
| A | 9 | 12 |
| A | 10 | 12 |
| A | 11 | 12 |
| A | 12 | 12 |
| B | 1 | 138 |
| B | 2 | 138 |
| B | 3 | 138 |
| B | 4 | 138 |
| B | 5 | 138 |
| B | 6 | 138 |
| B | 7 | 138 |
| B | 8 | 138 |
| B | 9 | 138 |
| B | 10 | 138 |
| B | 11 | 138 |
| B | 12 | 138 |
| B | 13 | 138 |
| B | 14 | 138 |
| B | 15 | 138 |
| B | 16 | 138 |
| B | 17 | 138 |
| B | 18 | 138 |
| B | 19 | 138 |
| B | 20 | 138 |
| B | 21 | 138 |
| B | 22 | 138 |
| B | 23 | 138 |
| B | 24 | 138 |
| B | 25 | 138 |
| B | 26 | 138 |
| B | 27 | 138 |
| B | 28 | 138 |
| B | 29 | 138 |
| B | 30 | 138 |
| B | 31 | 138 |
| B | 32 | 138 |
| B | 33 | 138 |
| B | 34 | 138 |
| B | 35 | 138 |
| B | 36 | 138 |
| B | 37 | 138 |
| B | 38 | 138 |
| B | 39 | 138 |
| B | 40 | 138 |
| B | 41 | 138 |
| B | 42 | 138 |
| B | 43 | 138 |
| B | 44 | 138 |
| B | 45 | 138 |
| B | 46 | 138 |
| B | 47 | 138 |
| B | 48 | 138 |
| B | 49 | 138 |
| B | 50 | 138 |
| B | 51 | 138 |
| B | 52 | 138 |
| B | 53 | 138 |
| B | 54 | 138 |
| B | 55 | 138 |
| B | 56 | 138 |
| B | 57 | 138 |
| B | 58 | 138 |
| B | 59 | 138 |
| B | 60 | 138 |
| B | 61 | 138 |
| B | 62 | 138 |
| B | 63 | 138 |
| B | 64 | 138 |
| B | 65 | 138 |
| B | 66 | 138 |
| B | 67 | 138 |
| B | 68 | 138 |
| B | 69 | 138 |
| B | 70 | 138 |
| B | 71 | 138 |
| B | 72 | 138 |
| B | 73 | 138 |
| B | 74 | 138 |
| B | 75 | 138 |
| B | 76 | 138 |
| B | 77 | 138 |
| B | 78 | 138 |
| B | 79 | 138 |
| B | 80 | 138 |
| B | 81 | 138 |
| B | 82 | 138 |
| B | 83 | 138 |
| B | 84 | 138 |
| B | 85 | 138 |
| B | 86 | 138 |
| B | 87 | 138 |
| B | 88 | 138 |
| B | 89 | 138 |
| B | 90 | 138 |
| B | 91 | 138 |
| B | 92 | 138 |
| B | 93 | 138 |
| B | 94 | 138 |
| B | 95 | 138 |
| B | 96 | 138 |
| B | 97 | 138 |
| B | 98 | 138 |
| B | 99 | 138 |
| B | 100 | 138 |
| B | 101 | 138 |
| B | 102 | 138 |
| B | 103 | 138 |
| B | 104 | 138 |
| B | 105 | 138 |
| B | 106 | 138 |
| B | 107 | 138 |
| B | 108 | 138 |
| B | 109 | 138 |
| B | 110 | 138 |
| B | 111 | 138 |
| B | 112 | 138 |
| B | 113 | 138 |
| B | 114 | 138 |
| B | 115 | 138 |
| B | 116 | 138 |
| B | 117 | 138 |
| B | 118 | 138 |
| B | 119 | 138 |
| B | 120 | 138 |
| B | 121 | 138 |
| B | 122 | 138 |
| B | 123 | 138 |
| B | 124 | 138 |
| B | 125 | 138 |
| B | 126 | 138 |
| B | 127 | 138 |
| B | 128 | 138 |
| B | 129 | 138 |
| B | 130 | 138 |
| B | 131 | 138 |
| B | 132 | 138 |
| B | 133 | 138 |
| B | 134 | 138 |
| B | 135 | 138 |
| B | 136 | 138 |
| B | 137 | 138 |
| B | 138 | 138 |
| ID | LVL | CNT |
|---|---|---|
| A | 1 | 12 |
| A | 2 | 12 |
| A | 3 | 12 |
| A | 4 | 12 |
| A | 5 | 12 |
| A | 6 | 12 |
| A | 7 | 12 |
| A | 8 | 12 |
| A | 9 | 12 |
| A | 10 | 12 |
| A | 11 | 12 |
| A | 12 | 12 |
| B | 1 | 138 |
| B | 2 | 138 |
| B | 3 | 138 |
| B | 4 | 138 |
| B | 5 | 138 |
| B | 6 | 138 |
| B | 7 | 138 |
| B | 8 | 138 |
| B | 9 | 138 |
| B | 10 | 138 |
| B | 11 | 138 |
| B | 12 | 138 |
| B | 13 | 138 |
| B | 14 | 138 |
| B | 15 | 138 |
| B | 16 | 138 |
| B | 17 | 138 |
| B | 18 | 138 |
| B | 19 | 138 |
| B | 20 | 138 |
| B | 21 | 138 |
| B | 22 | 138 |
| B | 23 | 138 |
| B | 24 | 138 |
| B | 25 | 138 |
| B | 26 | 138 |
| B | 27 | 138 |
| B | 28 | 138 |
| B | 29 | 138 |
| B | 30 | 138 |
| B | 31 | 138 |
| B | 32 | 138 |
| B | 33 | 138 |
| B | 34 | 138 |
| B | 35 | 138 |
| B | 36 | 138 |
| B | 37 | 138 |
| B | 38 | 138 |
| B | 39 | 138 |
| B | 40 | 138 |
| B | 41 | 138 |
| B | 42 | 138 |
| B | 43 | 138 |
| B | 44 | 138 |
| B | 45 | 138 |
| B | 46 | 138 |
| B | 47 | 138 |
| B | 48 | 138 |
| B | 49 | 138 |
| B | 50 | 138 |
| B | 51 | 138 |
| B | 52 | 138 |
| B | 53 | 138 |
| B | 54 | 138 |
| B | 55 | 138 |
| B | 56 | 138 |
| B | 57 | 138 |
| B | 58 | 138 |
| B | 59 | 138 |
| B | 60 | 138 |
| B | 61 | 138 |
| B | 62 | 138 |
| B | 63 | 138 |
| B | 64 | 138 |
| B | 65 | 138 |
| B | 66 | 138 |
| B | 67 | 138 |
| B | 68 | 138 |
| B | 69 | 138 |
| B | 70 | 138 |
| B | 71 | 138 |
| B | 72 | 138 |
| B | 73 | 138 |
| B | 74 | 138 |
| B | 75 | 138 |
| B | 76 | 138 |
| B | 77 | 138 |
| B | 78 | 138 |
| B | 79 | 138 |
| B | 80 | 138 |
| B | 81 | 138 |
| B | 82 | 138 |
| B | 83 | 138 |
| B | 84 | 138 |
| B | 85 | 138 |
| B | 86 | 138 |
| B | 87 | 138 |
| B | 88 | 138 |
| B | 89 | 138 |
| B | 90 | 138 |
| B | 91 | 138 |
| B | 92 | 138 |
| B | 93 | 138 |
| B | 94 | 138 |
| B | 95 | 138 |
| B | 96 | 138 |
| B | 97 | 138 |
| B | 98 | 138 |
| B | 99 | 138 |
| B | 100 | 138 |
| B | 101 | 138 |
| B | 102 | 138 |
| B | 103 | 138 |
| B | 104 | 138 |
| B | 105 | 138 |
| B | 106 | 138 |
| B | 107 | 138 |
| B | 108 | 138 |
| B | 109 | 138 |
| B | 110 | 138 |
| B | 111 | 138 |
| B | 112 | 138 |
| B | 113 | 138 |
| B | 114 | 138 |
| B | 115 | 138 |
| B | 116 | 138 |
| B | 117 | 138 |
| B | 118 | 138 |
| B | 119 | 138 |
| B | 120 | 138 |
| B | 121 | 138 |
| B | 122 | 138 |
| B | 123 | 138 |
| B | 124 | 138 |
| B | 125 | 138 |
| B | 126 | 138 |
| B | 127 | 138 |
| B | 128 | 138 |
| B | 129 | 138 |
| B | 130 | 138 |
| B | 131 | 138 |
| B | 132 | 138 |
| B | 133 | 138 |
| B | 134 | 138 |
| B | 135 | 138 |
| B | 136 | 138 |
| B | 137 | 138 |
| B | 138 | 138 |