CREATE TABLE stock (
id INT AUTO_INCREMENT,
model VARCHAR(100),
storage VARCHAR(100),
color VARCHAR(100),
PRIMARY KEY (id)
);
INSERT INTO stock(id, model, storage, color) VALUES
(1, 'iPhone 14 Pro', '128gb', 'Black'),
(2, 'iPhone 14 Pro', '256gb', 'Red'),
(3, 'iPhone 14 Pro', '128gb', 'Black'),
(4, 'iPhone 14 Pro', '256gb', 'Black'),
(5, 'iPhone 14 Pro', '256gb', 'Red'),
(6, 'iPhone 14 Pro', '128gb', 'White'),
(7, 'iPhone 13 Pro', '128gb', 'Black'),
(8, 'iPhone 14 Pro', '256gb', 'Red');