March 1 - Product 1 - Sold 30
March 1 - Product 1 - Sold 10
March 1 - Product 2 - Sold 10


March 2 - Product 3 - Sold 10
March 2 - Product 1 - Sold 10
March 2 - Product 3 - Sold 15

March 1- Product 1: 40, Product 2: 10
March 2- Product 1: 50, Product 2: 10, Product 3: 25

CREATE TABLE sales(dt DATETIME, productName VARCHAR(100), amount INT)

INSERT INTO sales SELECT getdate(), 'Product 1', 10
INSERT INTO sales SELECT getdate(), 'Product 1', 20
INSERT INTO sales SELECT getdate(), 'Product 2', 40
INSERT INTO sales SELECT getdate()-1, 'Product 1', 15
INSERT INTO sales SELECT getdate()-1, 'Product 1', 20
INSERT INTO sales SELECT getdate()-1, 'Product 2', 60

SELECT CONVERT(VARCHAR(10), s.dt, 120) AS DT, s.productName, SUM(s.amount) AS sumAmount
FROM sales s
GROUP BY CONVERT(VARCHAR(10), s.dt, 120), s.productName