By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| brand | units | Highest |
|---|---|---|
| A | 200.000000000000 | 1500.000000000000 |
| B | 0.000000000000 | 1500.000000000000 |
| C | 300.000000000000 | 1500.000000000000 |
| D | 400.000000000000 | 1500.000000000000 |
| E | 1500.000000000000 | 1500.000000000000 |
| F | 700.000000000000 | 1500.000000000000 |
| G | 800.000000000000 | 1500.000000000000 |
| H | 450.000000000000 | 1500.000000000000 |