By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | type | subtype | pos | c_ads |
|---|---|---|---|---|
| 3 | dating | 3 | 2 | |
| 5 | dating | girls | 2 | 2 |
| 4 | dating | boys | 1 | 2 |
| 2 | jobs | 2 | null | |
| 5 | jobs | teacher | 1 | null |
| 1 | sell | 1 | 1 | |
| 5 | sell | cars | 1 | 1 |
| id | type | subtype | pos | c_ads |
|---|---|---|---|---|
| 3 | dating | 3 | 2 | |
| 5 | dating | girls | 2 | 2 |
| 4 | dating | boys | 1 | 2 |
| 2 | jobs | 2 | null | |
| 5 | jobs | teacher | 1 | null |
| 1 | sell | 1 | 1 | |
| 5 | sell | cars | 1 | 1 |