CREATE TABLE Products (
  product_ID INTEGER PRIMARY KEY,
  product_name VARCHAR (30),
  category_ID INTEGER,
  model_year YEAR,
  list_price decimal (4,2)
);
-- insert some values
INSERT INTO Products VALUES ('280', 'Trek Superfly 24 - 2017/2018', '1', '2018', '489.99');
INSERT INTO Products VALUES ('266', 'Trek Superfly 20 - 2018', '1', '2018', '399.99');
INSERT INTO Products VALUES ('288', 'Electra Straight 8 1(20-inch) - Boys - 2018', '1', '2018', '389.99');
INSERT INTO Products VALUES ('290', 'Electra Superbolt 3i 20" - 2018', '1', '2018', '369.99');
INSERT INTO Products VALUES ('292', 'Electra Sweet Ride 3i (20-inch) - Girls - 2018', '1', '2018', '369.99');
INSERT INTO Products VALUES ('294', 'Electra Tiger Shark 3i (20-inch) - Boys - 2018', '1', '2018', '369.99');
INSERT INTO Products VALUES ('296', 'Electra Treasure 3i 20" - 2018', '1', '2018', '369.99');
INSERT INTO Products VALUES ('277', 'Trek Precaliber 24 21-speed Boys - 2018', '1', '2018', '369.99');

-- fetch some values
SELECT * FROM Products