By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 4 Duplicates: 0 Warnings: 0
| id | property_id | plot_id | no_sqyds |
|---|---|---|---|
| 1 | 1 | 1 | 25 |
| 2 | 1 | 2 | 50 |
| 3 | 1 | 1 | 25 |
| 4 | 1 | 3 | 50 |
| id | name |
|---|---|
| 1 | Lake View Park |
Records: 3 Duplicates: 0 Warnings: 0
| id | property_id | no_sqyds |
|---|---|---|
| 1 | 1 | 50 |
| 2 | 1 | 75 |
| 3 | 1 | 100 |
| plot_id | purchase_percent |
|---|---|
| 1 | 100 |
| 2 | 67 |
| 3 | 50 |