Optimizing Joins: How to Get a Distinct Count from Two Tables

How to Use Lateral Joins to Get the Most Recent Exchange Rate for Each Transaction in PostgreSQL