Using FIRST_VALUE to find the first occurrence of a shipping cost in a dataset
Using FIRST_VALUE to find the first occurrence of a tax rate in a dataset
Using FIRST_VALUE to find the first occurrence of a discount amount in a dataset
Using FIRST_VALUE to find the first occurrence of a promotion code in a dataset
Using FIRST_VALUE to find the first occurrence of a payment method in a dataset