How to Use First Value Window Function in AWS Timestream for Latest Non-Grouped Column Values

Understanding How to Filter on Aggregates in AWS Timestream Queries