By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
18 rows affected
| ID | TenderType | BidAmount | IsAwardCarrier | BidSuccess |
|---|---|---|---|---|
| 1 | Spot Bid | null | False | False |
| 1 | Spot Bid | null | False | False |
| 1 | Spot Bid | null | False | False |
| 1 | Spot Bid | null | False | False |
| 1 | Spot Bid | 390 | False | False |
| 1 | Spot Bid | 345 | True | True |
| 1 | Spot Bid | null | False | False |
| 1 | Spot Bid | 653 | False | False |
| 1 | Ordinary | null | True | True |
| 2 | Spot Bid | null | False | False |
| 2 | Spot Bid | null | False | False |
| 2 | Spot Bid | null | False | False |
| 2 | Spot Bid | null | False | False |
| 2 | Spot Bid | 4150 | True | False |
| 2 | Spot Bid | 3365 | False | True |
| 2 | Spot Bid | null | False | False |
| 2 | Spot Bid | 3607 | False | False |
| 2 | Ordinary | null | True | False |
Warning: Null value is eliminated by an aggregate or other SET operation.