Using FIRST_VALUE to find the first occurrence of a customer name in a dataset
Using FIRST_VALUE to find the first occurrence of an order status in a dataset
Using FIRST_VALUE to find the first occurrence of a product name in a dataset
Using FIRST_VALUE to find the first occurrence of a country name in a dataset
Using FIRST_VALUE to find the first occurrence of a city name in a dataset