By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ACCOUNTNO | SYMBOL | AMOUNT | R |
|---|---|---|---|
| A1 | IBM | 10 | 16.67 |
| A1 | GOOG | 30 | 50.00 |
| A1 | CSCO | 20 | 33.33 |
| A2 | IBM | 40 | 80.00 |
| A2 | FB | 10 | 20.00 |
| ACCOUNTNO | SYMBOL | AMOUNT | R |
|---|---|---|---|
| A1 | IBM | 10 | 16.67 |
| A1 | GOOG | 30 | 50.00 |
| A1 | CSCO | 20 | 33.33 |
| A2 | IBM | 40 | 80.00 |
| A2 | FB | 10 | 20.00 |