Sahurlu gözlerle yazdım ben de bilmem çalışır mı

SELECT pi.price, count(*) FROM SOLDPRODUCTS sp
INNER JOIN PRODUCT p ON sp.product = productId
INNER JOIN PRODUCTINFORMATION pi ON pi.productInformationID = p.productInformationID
group by sp.product
ORDER BY count(*) DESC LIMIT 1