By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | city | fishing_segment |
|---|---|---|
| 1 | Jakarta Credit | 6000 |
| 2 | Loan Jakarta | 5000 |
| 3 | Bali Credit | 4000 |
| 4 | Loan Bali | 3000 |
| 5 | Bandung Credit | 2000 |
| 6 | Loan Bandung | 1000 |
| id | City with credit | fishing_segment |
|---|---|---|
| 1 | Jakarta Credit | 6000 |
| 3 | Bali Credit | 4000 |
| 5 | Bandung Credit | 2000 |
| id | City with loan | fishing_segment |
|---|---|---|
| 2 | Loan Jakarta | 5000 |
| 4 | Loan Bali | 3000 |
| 6 | Loan Bandung | 1000 |
| city | credit_ids | credit_fishing_segment | loan_ids | loan_fishing_segment |
|---|---|---|---|---|
| Bali | 3 | 4000 | 4 | 3000 |
| Bandung | 5 | 2000 | 6 | 1000 |
| Jakarta | 1 | 6000 | 2 | 5000 |