create database db_sales;
create table sales
(
    saleID int Auto_Increment primary key , ProductName varchar(30), Quantity int, Price int
);
Insert into sales
    (ProductName, Quantity, Price)
Values
    ("Soap", 4, 200),
    ("Bodywash", 6, 300),
    ("Grain", 7, 900),
    ("HArpic", 8, 400),
    ("Soap", 4, 200);
    

Select ProductName, Sum(Quantity)
from sales
Group By ProductName;