Mаnаgement wаnts a categоry-level sales summary. Write a query shоwing fоr each product category:category, total_products_sold, total_revenue, avg_purchase_amount, highest_purchase total_products_sold = total quantity sold across all purchases total_revenue = sum of all purchase amounts avg_purchase_amount = average purchase amount highest_purchase = the single largest purchase amount in that category Sorted by total_revenue descending. Table: products, purchases