
You are given Acumen transaction data and a product mapping table. Write a PostgreSQL query that breaks down performance by business line, returning each business line’s total revenue, transaction count, and average revenue per transaction. Any transaction whose product has a null or missing business line should be grouped into an Unmapped bucket.