By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Title | BookNo | Status |
|---|---|---|
| Book 1 | 123 | 1 |
| Book 1 | 123 | 1 |
| Book 1 | 123 | 1 |
| Book 1 | 123 | 1 |
| Book 2 | 456 | 1 |
| Book 2 | 456 | 0 |
| Book 2 | 456 | 0 |
| Book 2 | 456 | 1 |
| Book 3 | 789 | 0 |
| Book 3 | 789 | 1 |
| RowNumber | Title | BookNo | CopiesAmount | CopiesWithStatus_1 |
|---|---|---|---|---|
| 1 | Book 1 | 123 | 4 | 4 |
| 2 | Book 2 | 456 | 4 | 2 |
| 3 | Book 3 | 789 | 2 | 1 |