SQLize | PHPize | SQLtest

CREATE TABLE Products ( product_id BIGINT NOT NULL PRIMARY KEY, product_name VARCHAR(64) NOT NULL, category VARCHAR(64) NOT NULL, price INT NOT NULL ); CREATE TABLE Orders ( order_id BIGINT NOT NULL PRIMARY KEY, product_id BIGINT NOT NULL, quantity INT NOT NULL, order_date DATE NOT NULL, CONSTRAINT product_id_fk FOREIGN KEY (product_id) REFERENCES Products (product_id) ); INSERT INTO Products (product_id, product_name, category, price) VALUES (1, 'Laptop', 'Electronics', 1000), (2, 'Smartphone', 'Electronics', 500), (3, 'Table', 'Furniture', 150), (4, 'Chair', 'Furniture', 75); INSERT INTO Orders (order_id, product_id, quantity, order_date) VALUES (1, 1, 2, '2023-01-15'), (2, 2, 1, '2023-02-20'), (3, 3, 4, '2023-03-05'), (4, 4, 3, '2023-04-10'), (5, 1, 1, '2023-05-22'); SELECT UPPER(LEFT('sql-academy', 3)) AS str;