gistfile1.txt

CREATE DATABASE ITstep2;

CREATE TABLE Restauran2(
id int PRIMARY KEY,
name varchar(100) NOT NULL,
category varchar(100),
price int,
discount float,
quantity int,
measurement varchar(50),
producer varchar(100),
country varchar(100),
supplier varchar(100),
date_of_delivery DATE,
expire_date DATE,
);

INSERT INTO Restauran2 (id, name, category, price, discount, quantity, measurement, producer, country, supplier, date_of_delivery, expire_date)  
VALUES  
(1, 'Den', 'Tree', 10, 5, 30, 'KG', 'Prod1', 'USA', 'Apple', '2025-03-01', '2025-06-01'),  
(2, 'Maks', 'Table', 15, 3, 25, 'L', 'Prod2', 'Germany', 'Windows', '2025-03-02', '2025-06-02'),  
(3, 'Alex', 'Chair', 20, 8, 40, 'PCS', 'Prod3', 'France', 'Gucci', '2025-03-03', '2025-06-03'),  
(4, 'Luna', 'Lamp', 18, 6, 22, 'KG', 'Prod4', 'Italy', 'Zara', '2025-03-04', '2025-06-04'),  
(5, 'Niko', 'Bed', 25, 4, 35, 'L', 'Prod5', 'Spain', 'Sumsung', '2025-03-05', '2025-06-05'),  
(6, 'Simlpe', 'Closet', 30, 7, 50, 'PCS', 'Prod6', 'UK', 'Android', '2025-03-06', '2025-06-06'),  
(7, 'Monesy', 'Nightstand', 22, 5, 28, 'KG', 'Prod7', 'Canada', 'Gucci', '2025-03-07', '2025-06-07'),  
(8, 'Donk', 'Laptop', 17, 2, 20, 'L', 'Prod8', 'Mexico', 'Volga', '2025-03-08', '2025-06-08'),  
(9, 'Nikita', 'Blanket', 27, 9, 45, 'PCS', 'Prod9', 'Brazil', 'Mercedes', '2025-03-09', '2025-06-09'),  
(10, 'Ivan', 'Laptop', 19, 3, 26, 'KG', 'Prod10', 'Japan', 'Audi', '2025-03-10', '2025-06-10'),  
(11, 'Bob', 'Chair', 23, 6, 33, 'L', 'Prod11', 'China', 'LG', '2025-03-11', '2025-06-11'),  
(12, 'Misha', 'Bed', 21, 5, 27, 'PCS', 'Prod12', 'India', 'Intel', '2025-03-12', '2025-06-12'),  
(13, 'Hovard', 'Table', 16, 4, 19, 'KG', 'Prod13', 'Russia', 'Ryzen', '2025-03-13', '2025-06-13'),  
(14, 'Egor', 'Tree', 29, 8, 55, 'L', 'Prod14', 'Australia', 'LG', '2025-03-14', '2025-06-14'),  
(15, 'Mark', 'Red wood', 14, 3, 18, 'PCS', 'Prod15', 'South Korea', 'Apple', '2025-03-15', '2025-06-15'),  
(16, 'Renat', 'Red wood', 35, 10, 60, 'KG', 'Prod16', 'Argentina', 'Gucci', '2025-03-16', '2025-06-16'),  
(17, 'Diana', 'Closet', 12, 2, 15, 'L', 'Prod17', 'South Africa', 'Zara', '2025-03-17', '2025-06-17'),  
(18, 'Darina', 'Lamp', 32, 7, 48, 'PCS', 'Prod18', 'Turkey', 'Android', '2025-03-18', '2025-06-18'),  
(19, 'Bohdan', 'Sofa', 24, 6, 36, 'KG', 'Prod19', 'Egypt', 'Navi', '2025-03-19', '2025-06-19'),  
(20, 'Elvis', 'Sink', 28, 9, 44, 'L', 'Prod20', 'Sweden', 'G2', '2025-03-20', '2025-06-20');