Create table dorilar ( Id serial primary key, Nom varchar(50) not null

CREATE TABLE Dorilar (
Id SERIAL PRIMARY KEY,
Nom VARCHAR(50) NOT NULL,
Narxi INTEGER NOT NULL,
Sana DATE NOT NULL,
Turi VARCHAR(50) NOT NULL,
Soni INTEGER NOT NULL
);

INSERT INTO Dorilar (nom, narxi, sana, turi, soni) VALUES

(‘Aspirin’, 5000, ‘2021-10-01’, ‘Tabletka’, 100),
(‘Paratsetamol’, 3000, ‘2021-10-02’, ‘Kapsula’, 50),
(‘Ibuprofen’, 7000, ‘2021-10-03’, ‘Tabletka’, 75),
(‘Amoksisilin’, 10000, ‘2021-10-04’, ‘Kapsula’, 30),
(‘Deksametazon’, 15000, ‘2021-10-05’, ‘In’ektsiya’, 20),
(‘Nimesulid’, 6000, ‘2021-10-06’, ‘Tabletka’, 80);