Using FIRST_VALUE to find the first occurrence of a boolean value in a dataset
Using FIRST_VALUE to find the first occurrence of a date in a dataset
Using FIRST_VALUE to find the first occurrence of a number in a dataset
Using FIRST_VALUE to find the first occurrence of a specific word in a dataset
Using FIRST_VALUE to find the first occurrence of a certain pattern in a dataset