SELECT * FROM (
-- SELECT MOST EXPENSIVE PRODUCT
SELECT TOP(1) ProdID, Name
FROM Product
ORDER BY Price DESC
) ExpensiveProd
JOIN (
-- CALCULATE SALES BY PRODUCT IN DATE INTERVAL
SELECT ProdID, SUM(Sum) ProdSales
FROM Sales
WHERE Date BETWEEN '2019-07-01' AND '2019-07-31' GROUP BY ProdID
) ProdSales ON ProdSales.ProdID = ExpensiveProd.ProdID;