By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| PN | SN | Num |
|---|---|---|
| A0001 | S0001 | 1 |
| A0001 | S0005 | 1 |
| A0002 | S0004 | 1 |
| PN | SN | Num |
|---|---|---|
| A0001 | S0001 | 0 |
| A0001 | S0002 | 0 |
| A0001 | S0003 | 0 |
| A0001 | S0005 | 0 |
| A0001 | S0006 | 0 |
| A0001 | S0007 | 0 |
| A0002 | S0004 | 0 |
| A0002 | S0008 | 0 |