Average Deal Size

You have a table called deals that records sales transactions. deal_id acts as the primary key. Every row documents a single sales deal. Write a query that computes the average deal size for each product, but only include products that have more than one deal overall (counting across all managers). Round each average to exactly two decimal places. Your output should contain two columns: product and avg_deal_size. Sort the results alphabetically by product. The expected…