SQL masterclass 1.0

-- Create a products table
DROP TABLE IF EXISTS products;
CREATE TABLE products (
        product_name                   VARCHAR,
        unit_price                     FLOAT
);

-- Insert data to products table
INSERT INTO products VALUES ('Bananas', 1.25);
INSERT INTO products VALUES ('Nuts', 1.35);
INSERT INTO products VALUES ('Milk', 0.96);
INSERT INTO products VALUES ('Bread', 0.77);

-- Create a sales table
DROP TABLE IF EXISTS sales;
CREATE TABLE sales (
        sale_dt                        DATE,
        product                        VARCHAR,
        quantity                       INTEGER,
        price                          FLOAT
);

-- Insert data to sales table
INSERT INTO sales VALUES ('2016-01-01', 'Bananas', 5, 6.25);
INSERT INTO sales VALUES ('2016-01-02', 'Bananas', 3, 3.75);
INSERT INTO sales VALUES ('2016-01-03', 'Bananas', 7, 8.75);
INSERT INTO sales VALUES ('2016-01-03', 'Nuts', 23, 31.05);
INSERT INTO sales VALUES ('2016-01-04', 'Bananas', 3, 3.75);
INSERT INTO sales VALUES ('2016-01-04', 'Nuts', 31, 41.85);
INSERT INTO sales VALUES ('2016-01-05', 'Bananas', 6, 7.5);
INSERT INTO sales VALUES ('2016-01-06', 'Milk', 7, 6.72);
INSERT INTO sales VALUES ('2016-01-06', 'Nuts', 24, 32.4);
INSERT INTO sales VALUES ('2016-01-08', 'Bananas', 4, 5);
INSERT INTO sales VALUES ('2016-01-08', 'Milk', 8, 7.68);
INSERT INTO sales VALUES ('2016-01-08', 'Nuts', 29, 39.15);
INSERT INTO sales VALUES ('2016-01-09', 'Bananas', 12, 15);
INSERT INTO sales VALUES ('2016-01-09', 'Milk', 4, 3.84);
INSERT INTO sales VALUES ('2016-01-09', 'Nuts', 14, 18.9);
INSERT INTO sales VALUES ('2016-01-13', 'Bananas', 1, 1.25);
INSERT INTO sales VALUES ('2016-01-13', 'Milk', 7, 6.72);
INSERT INTO sales VALUES ('2016-01-17', 'Bananas', 7, 8.75);
INSERT INTO sales VALUES ('2016-01-18', 'Milk', 5, 4.8);
INSERT INTO sales VALUES ('2016-01-19', 'Milk', 6, 5.76);
---