SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Product ( ProdID int, Name varchar(64), Price int ); INSERT INTO Product VALUES (1, 'Simple Prod', 100), (2, 'Most Expensive Prod', 1000); CREATE TABLE Sales ( Date date, ProdID int, Sum int ); INSERT INTO Sales VALUES ('2019-05-01', 2, 2000), ('2019-07-01', 1, 200), ('2019-07-01', 2, 2000), ('2019-07-10', 1, 1000); SELECT TOP(1) ProdID, Name FROM Product ORDER BY Price DESC; SELECT ProdID, SUM(Sum) FROM Sales WHERE Date BETWEEN '2019-07-01' AND '2019-07-31' GROUP BY ProdID; 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;