By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
40 rows affected
| testid | numerator | denominator |
|---|---|---|
| 1 | 28 | 49 |
| 2 | -28 | -49 |
| 3 | 28 | -49 |
| 4 | -28 | 49 |
| 5 | 22 | 6 |
| 6 | -22 | -6 |
| 7 | 22 | -6 |
| 8 | -22 | 6 |
| 9 | 28 | 14 |
| 10 | -28 | -14 |
| 11 | 28 | -14 |
| 12 | -28 | 14 |
| 13 | 7919 | 2687 |
| 14 | -7 | -2 |
| 15 | 11 | -17 |
| 16 | -19 | 9 |
| 17 | 15 | -3 |
| 18 | -20 | 4 |
| 19 | -10 | -2 |
| 20 | 5 | 1 |
| 21 | 1 | 1 |
| 22 | -1 | -1 |
| 23 | 1 | -1 |
| 24 | -1 | 1 |
| 25 | -7 | -7 |
| 26 | 7 | -7 |
| 27 | 0 | 2 |
| 28 | 0 | -2 |
| 29 | 0 | 1 |
| 30 | 0 | -1 |
| 31 | 2 | 0 |
| 32 | -100 | 0 |
| 33 | 0 | 0 |
| 34 | 10 | null |
| 35 | -5 | null |
| 36 | 0 | null |
| 37 | null | 11 |
| 38 | null | -8 |
| 39 | null | 0 |
| 40 | null | null |
| testid | numerator | denominator | val1 | val2 | lev | testid | numerator | denominator | val1 | val2 | lev | ?column? | ?column? |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 28 | 49 | 0 | 7 | 3 | 1 | 28 | 49 | 0 | 7 | 3 | 4 | 7 |
| 2 | -28 | -49 | 0 | 7 | 3 | 2 | -28 | -49 | 0 | 7 | 3 | -4 | -7 |
| 3 | 28 | -49 | 0 | 7 | 3 | 3 | 28 | -49 | 0 | 7 | 3 | 4 | -7 |
| 4 | -28 | 49 | 0 | 7 | 3 | 4 | -28 | 49 | 0 | 7 | 3 | -4 | 7 |
| 5 | 22 | 6 | 0 | 2 | 3 | 5 | 22 | 6 | 0 | 2 | 3 | 11 | 3 |
| 6 | -22 | -6 | 0 | 2 | 3 | 6 | -22 | -6 | 0 | 2 | 3 | -11 | -3 |
| 7 | 22 | -6 | 0 | 2 | 3 | 7 | 22 | -6 | 0 | 2 | 3 | 11 | -3 |
| 8 | -22 | 6 | 0 | 2 | 3 | 8 | -22 | 6 | 0 | 2 | 3 | -11 | 3 |
| 9 | 28 | 14 | 0 | 14 | 1 | 9 | 28 | 14 | 0 | 14 | 1 | 2 | 1 |
| 10 | -28 | -14 | 0 | 14 | 1 | 10 | -28 | -14 | 0 | 14 | 1 | -2 | -1 |
| 11 | 28 | -14 | 0 | 14 | 1 | 11 | 28 | -14 | 0 | 14 | 1 | 2 | -1 |
| 12 | -28 | 14 | 0 | 14 | 1 | 12 | -28 | 14 | 0 | 14 | 1 | -2 | 1 |
| 13 | 7919 | 2687 | 0 | 1 | 7 | 13 | 7919 | 2687 | 0 | 1 | 7 | 7919 | 2687 |
| 14 | -7 | -2 | 0 | 1 | 2 | 14 | -7 | -2 | 0 | 1 | 2 | -7 | -2 |
| 15 | 11 | -17 | 0 | 1 | 4 | 15 | 11 | -17 | 0 | 1 | 4 | 11 | -17 |
| 16 | -19 | 9 | 0 | 1 | 2 | 16 | -19 | 9 | 0 | 1 | 2 | -19 | 9 |
| 17 | 15 | -3 | 0 | 3 | 1 | 17 | 15 | -3 | 0 | 3 | 1 | 5 | -1 |
| 18 | -20 | 4 | 0 | 4 | 1 | 18 | -20 | 4 | 0 | 4 | 1 | -5 | 1 |
| 19 | -10 | -2 | 0 | 2 | 1 | 19 | -10 | -2 | 0 | 2 | 1 | -5 | -1 |
| 20 | 5 | 1 | 0 | 1 | 1 | 20 | 5 | 1 | 0 | 1 | 1 | 5 | 1 |
| 21 | 1 | 1 | 0 | 1 | 1 | 21 | 1 | 1 | 0 | 1 | 1 | 1 | 1 |
| 22 | -1 | -1 | 0 | 1 | 1 | 22 | -1 | -1 | 0 | 1 | 1 | -1 | -1 |
| 23 | 1 | -1 | 0 | 1 | 1 | 23 | 1 | -1 | 0 | 1 | 1 | 1 | -1 |
| 24 | -1 | 1 | 0 | 1 | 1 | 24 | -1 | 1 | 0 | 1 | 1 | -1 | 1 |
| 25 | -7 | -7 | 0 | 7 | 1 | 25 | -7 | -7 | 0 | 7 | 1 | -1 | -1 |
| 26 | 7 | -7 | 0 | 7 | 1 | 26 | 7 | -7 | 0 | 7 | 1 | 1 | -1 |