SELECT
	s_purchases.product_id AS order_product_id,
	SUM(s_purchases.price) AS totalprice,
	s_purchases.product_name AS product_name,
	COUNT(s_purchases.product_id) AS order_count,
	FROM s_purchases
	
	GROUP BY s_purchases.product_id ORDER BY SUM(s_purchases.price) DESC LIMIT 10