@pen one the GREATEST function can be used to find the latest of two or more dates within a single result (not aggregate/grouped results)