A department store maintains data on customers, products, and purchase records in three tables: customer, product, and purchase. The store manager wants to find the average price of all distinct products that are purchased within a category for each category. Write a query to print category and the average of price minus discount for the distinct products that are purchased in the category for each category.