Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
enrj
CREATE TABLE Gamintojas ( Gamintojo_kodas CHAR(4) NOT NULL, Pavadinimas VARCHAR(35) NOT NULL, PRIMARY KEY (Gamintojo_kodas) ); CREATE TABLE Sandelis ( Nr SMALLINT NOT NULL, Daiktu_sk SMALLINT CHECK (Daiktu_sk >= 0 AND Daiktu_sk < 50), PRIMARY KEY (Nr) ); CREATE TABLE Uzsakymas ( Nr CHAR(7) NOT NULL, Pirkejas CHAR(6) NOT NULL, Prekiu_kiekis SMALLINT NOT NULL, Suma DECIMAL(5,2) NOT NULL CHECK(Suma > 10 AND Suma < 3000), Uzsakymo_data DATE NOT NULL, Issiuntimo_data DATE NOT NULL CHECK (Issiuntimo_data >= Uzsakymo_data), PRIMARY KEY (Nr) ); CREATE TABLE Preke ( Kodas CHAR(5) NOT NULL, Pavadinimas VARCHAR(35) NOT NULL, SN CHAR(7), Gamintojas CHAR(4) NOT NULL, Kaina DECIMAL(4,2) NOT NULL CONSTRAINT Kainos_dydis CHECK (Kaina > 0 AND Kaina < 300), Uzsakymas CHAR(7) NOT NULL, Sandelis SMALLINT NOT NULL, PRIMARY KEY (Kodas) ); CREATE TABLE Pirkejas ( Pirkejo_ID CHAR(6) NOT NULL, Vardas VARCHAR(35) NOT NULL, Pavarde VARCHAR(35) NOT NULL, Adresas VARCHAR(35) NOT NULL, Telefono_nr CHAR(9) NOT NULL, PRIMARY KEY(Pirkejo_ID) ); INSERT INTO Gamintojas VALUES ('1234', 'ROZET'); INSERT INTO Gamintojas VALUES ('4356', 'KOM'); INSERT INTO Gamintojas VALUES ('7534', 'FIJI'); INSERT INTO Gamintojas VALUES ('2434', 'RAPOI'); INSERT INTO Sandelis VALUES (01, 6); INSERT INTO Sandelis VALUES (02, 5); INSERT INTO Sandelis VALUES (03, 11); INSERT INTO Sandelis VALUES (04, 0); INSERT INTO Sandelis VALUES (05, 3); INSERT INTO Uzsakymas VALUES ('G65UGJY', 'JA0026', 5, 123.66, '2020-04-11', '2020-06-05'); INSERT INTO Uzsakymas VALUES ('DFJY5HJ', 'AJ0112', 8, 568.99, '2020-05-24', '2020-06-30'); INSERT INTO Uzsakymas VALUES ('KHJ6567', 'AA0121', 2, 54.54, '2020-04-29', '2020-05-31'); INSERT INTO Uzsakymas VALUES ('SDJKD74', 'NP0014', 5, 111.89, '2020-05-01', '2020-06-04'); INSERT INTO Uzsakymas VALUES ('ERLKJ58', 'GG0018', 4, 23.00, '2020-05-17', '2020-06-01'); INSERT INTO Uzsakymas VALUES ('283DJ44', 'JA0026', 1, 12.69, '2020-04-25', '2020-05-31'); INSERT INTO Pirkejas VALUES ('AJ0112', 'Adomas', 'Jonaitis', 'Minija 1 - 1', '866780634'); INSERT INTO Pirkejas VALUES ('NP0014', 'Neringa', 'Petraityte', 'Upe 2 - 23', '868796785'); INSERT INTO Pirkejas VALUES ('GG0018', 'Gabija', 'Gigaityte', 'Tikslioji 67 - 23', '862435674'); INSERT INTO Pirkejas VALUES ('JA0026', 'Justinas', 'Andriukaitis', 'Mazuciai 11-25', '863416232'); INSERT INTO Pirkejas VALUES ('AA0121', 'Adomas', 'Andriulaitis', 'Upe 20 - 20', '8623ll344'); INSERT INTO Preke VALUES ('G4G4J', 'Zaidimu ausines', NULL, '4356', 24.67, 'G65UGJY', 03); INSERT INTO Preke VALUES ('BHH56', 'Belaides ausines', 'HN78776', '1234', 99.99, 'DFJY5HJ', 05); INSERT INTO Preke VALUES ('NKJ45', 'Optine laidine pele', NULL, '2434', 5.00, 'ERLKJ58', 01); INSERT INTO Preke VALUES ('35NMN', 'Klaviatura', 'AA4444', '1234', 158.89, 'DFJY5HJ', 03); INSERT INTO Preke VALUES ('J4JH4', 'Garso kolonele', NULL, '4356', 34.78, 'SDJKD74', 02); INSERT INTO Preke VALUES ('J54NL', 'Optine laidine pele', NULL, '2434', 5.00, 'G65UGJY', 03); INSERT INTO Preke VALUES ('5J4EF', 'Zaidimu ausines', NULL, '7534', 24.01, 'DFJY5HJ', 03); INSERT INTO Preke VALUES ('FDNK6', 'Optine laidine pele', NULL, '2434', 5.00, 'ERLKJ58', 02); INSERT INTO Preke VALUES ('N5N54', 'Ausiniu stovas', NULL, '4356', 13.99, 'G65UGJY', 01); INSERT INTO Preke VALUES ('LL223', 'Zaidimu pele', 'KL56411', '1234', 47.23, 'KHJ6567', 01); INSERT INTO Preke VALUES ('M3KM4', 'USB sakotuvas', NULL, '2434', 1.89, 'SDJKD74', 03); INSERT INTO Preke VALUES ('KM34K', 'Lazerine belaide pele', NULL, '4356', 44.44, 'DFJY5HJ', 03); INSERT INTO Preke VALUES ('23M33', 'Peles kilimelis', NULL, '2434', 4.55, 'ERLKJ58', 03); INSERT INTO Preke VALUES ('43M9M', 'Nesiojama garso kolonele', 'BV54534', '1234', 65.89, 'G65UGJY', 01); INSERT INTO Preke VALUES ('09SSD', 'Belaides ausines', 'HN66474', '1234', 99.99, 'DFJY5HJ', 03); INSERT INTO Preke VALUES ('JNAJ8', 'Lazerine belaide pele', NULL, '7534', 7.31, 'KHJ6567', 02); INSERT INTO Preke VALUES ('MKMK0', 'Vaizdo kamera', NULL, '2434', 14.11, 'G65UGJY', 03); INSERT INTO Preke VALUES ('MKI09', 'Belaides ausines', 'HN43544', '1234', 99.99, 'DFJY5HJ', 01); INSERT INTO Preke VALUES ('908IJ', 'Klaviatura', NULL, '2434', 19.99, 'SDJKD74', 03); INSERT INTO Preke VALUES ('46UI9', 'Klaviaturos rieso atrama', NULL, '4356', 21.48, 'DFJY5HJ', 05); INSERT INTO Preke VALUES ('SMNM8', 'Peles kilimelis', NULL, '2434', 12.69, '283DJ44', 02); INSERT INTO Preke VALUES ('1J1J1', 'Adapteris Type C/3.5mm', NULL, '2434', 8.45, 'ERLKJ58', 01); INSERT INTO Preke VALUES ('6NN6N', 'Klavaitura', NULL, '7534', 43.78, 'SDJKD74', 05); INSERT INTO Preke VALUES ('4354G', 'Mikrofonas', NULL, '7534', 20.20, 'DFJY5HJ', 03); INSERT INTO Preke VALUES ('4909H', 'Zaidimu pele', NULL, '2434', 11.45, 'SDJKD74', 02);
run
|
edit
|
history
|
help
0
Demo
jsonb handle
test_tags_count
E-Commerce SQL Analysis by Ran Li
PostreSQL: CASE
create myStudents table
pgsql trigger 01 - Ovocie
Replace key of json
Professional Networking Social Media Website SQL Analysis
cte