SELECT category, COUNT(product_id) AS total_products, AVG(price) AS average_price
FROM products
GROUP BY category
HAVING COUNT(product_id) > 5
ORDER BY total_products DESC;