Get the most recent transaction date

Hello to all the experts, I have a database, that contains Warehouses inventory. The columns are: Item ID / Warehouse name / qty. in WH / Last transaction date. My goal is: Get the most recent tr...