SQL/ZYBOOKS

Write the SQL to create a Product table with the following columns: ID - Integer Name - Variable-length string with maximum 40 characters Product Type - Variable-length string with maximum 3 characters OriginDate - Year, month, and day Weight - Decimal number with six significant digits and one digit after the decimal point Place your CREATE TABLE statement before the INSERT and SELECT statements. Run your solution and verify the result table contains the three inserted rows. 1 TABLE Product ( 2 ID INT, 234567 7); Name varchar(40), Product Type varchar(3), OriginDate Date Weight decimal 8 INSERT INTO Product (ID, Name, Product Type, OriginDate, Weight) VALUES 9 (100, 'Tricorder', 'TC', '2020-08-11', 2.4), 10 (200, 'Food replicator', 'FOD', '2020-09-21', 54.2), (300, 'Cloaking device', 'CD', '2019-02-04', 177.9); 11 12 13 SELECT * 14 FROM Product;