By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
26 rows affected
| ABC | Level | IsValid | MaxOfLevel |
|---|---|---|---|
| 10D34AV | 0 | No | 1 |
| 10D34AV | 1 | No | 1 |
| 10D35AV | 0 | No | 1 |
| 10D35AV | 1 | No | 1 |
| 10D36AV | 0 | Yes | 2 |
| 10D36AV | 1 | Yes | 2 |
| 10D36AV | 2 | Yes | 2 |
| 10D36AV | 2 | Yes | 2 |
| 10D36AV | 2 | Yes | 2 |
| 10D36AV | 1 | Yes | 2 |
| 10D36AV | 2 | Yes | 2 |
| 10D37AV | 0 | Yes | 2 |
| 10D37AV | 1 | Yes | 2 |
| 10D37AV | 2 | Yes | 2 |
| 10D37AV | 2 | Yes | 2 |
| 10D37AV | 1 | Yes | 2 |
| 10D37AV | 2 | Yes | 2 |
| 10D38AV | 0 | Yes | 2 |
| 10D38AV | 1 | Yes | 2 |
| 10D38AV | 2 | Yes | 2 |
| 10D38AV | 2 | Yes | 2 |
| 10D38AV | 2 | Yes | 2 |
| 10D38AV | 1 | Yes | 2 |
| 10D38AV | 2 | Yes | 2 |
| 10D39AV | 0 | No | 1 |
| 10D39AV | 1 | No | 1 |