/**
 * Create a table called Products that has four properties with these exact names.
 * id: A non-null, auto-incrementing integer that is the primary key.
 * title: A string that cannot be null.
 * description: A string that cannot be null.
 * price: A non-null, unsigned decimal that can store up to five digits total with two decimal places.
 */

CREATE TABLE Products (
    id INTEGER NOT NULL AUTO_INCREMENT,
    title VARCHAR(255) NOT NULL,
    description VARCHAR(255) NOT NULL,
    price DECIMAL(5,2) NOT NULL,

    PRIMARY KEY(id)
);

INSERT INTO Products(title, description, price) VALUES('My First Product', 'This is the first product I ever sold', 1.99);

UPDATE Products SET price = 49.99 WHERE id = 1;

SELECT * FROM Products WHERE price < 100;

DELETE FROM Products WHERE id = 1;