By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE inventory (
id int auto_increment primary key,
product VARCHAR(255),
quantity DECIMAL
);
INSERT INTO inventory
(product, quantity)
VALUES
('product_01', '800'),
('product_02', '300'),
('product_03', '200'),
('product_04', '500'),
('product_05', '600'),
('product_06', '400');
SELECT
iv.product AS product_name,
iv.product AS 'product name'
FROM inventory iv;
| product_name | product name |
|---|---|
| product_01 | product_01 |
| product_02 | product_02 |
| product_03 | product_03 |
| product_04 | product_04 |
| product_05 | product_05 |
| product_06 | product_06 |