I am trying to write a query with following fields:
The data has multiple records for each ID. The Insurance is always SP. I want to create a query that will return the
Max(Date) and the Amount associated with the Max(Date).