INSERT INTO KKAutor VALUES(1, 'Adam', 'Mickiewicz')
INSERT INTO KKAutor VALUES(2, 'Henryk', 'Sienkiewicz')
INSERT INTO KKAutor VALUES(3, 'Stefan', 'Żeromski')
INSERT INTO KKAutor VALUES(4, 'Aleksander', 'Solżenicyn')
SELECT imie, nazwisko FROM KKAutor
INSERT INTO KKKsiazka VALUES(1, 'Potop', 53.50, 24)
INSERT INTO KKKsiazka VALUES(3, 'Pan Tadeusz', null, 10)
INSERT INTO KKKsiazka VALUES(4, 'Trylogia', 999.00, 15)
INSERT INTO KKKsiazka VALUES(5, 'Ballady i romanse', 27.60, null)
INSERT INTO KKKsiazka VALUES(6, 'Archipelag Gulag', 15.90, 30)
INSERT INTO KKKsiazka_szczegoly VALUES(1, 0123456789, '10/05/09', 'twarda');
INSERT INTO KKKsiazka_szczegoly VALUES(3, 0123456788, '10/10/02', 'miekka');
INSERT INTO KKKsiazka_szczegoly VALUES(4, 0123456787, '09/01/12', 'miekka');
SELECT * FROM KKKsiazka_szczegoly
INSERT INTO KKKsiazka_szczegoly(Id_ksiazki, Data_wydania) VALUES (5, '07/03/12');
INSERT INTO KKKsiazka_szczegoly(Id_ksiazki,Oprawa, ISBN) VALUES (6, 'twarda', 0123456786);
SELECT * FROM KKAutor_ksiazka;
INSERT INTO KKAutor_ksiazka VALUES (1, 3);
INSERT INTO KKAutor_ksiazka VALUES (1, 5);
INSERT INTO KKAutor_ksiazka VALUES (2, 6);
INSERT INTO KKAutor_ksiazka VALUES (2, 4);
INSERT INTO KKAutor_ksiazka VALUES (3, 1);
INSERT INTO KKKsiazka VALUES(7, 'Sztuka zycia', 39.99, 30);
INSERT INTO KKAutor VALUES(5, 'Szczepan', 'Twardoch');
INSERT INTO KKAutor VALUES(6, 'Jan', 'Materna');
INSERT INTO KKAutor_ksiazka VALUES(5, 7);
INSERT INTO KKAutor_ksiazka VALUES(6, 7);
UPDATE KKKsiazka SET Cena = 800 WHERE Id_ksiazki = 4;
UPDATE KKKsiazka SET Cena = (Cena*1.1);
UPDATE KKKsiazka SET LICZBA = 20 WHERE Tytul = 'Ballady i romanse';
UPDATE KKKsiazka SET Cena = (Cena*0.95) WHERE Liczba > 20;
COMMIT
DELETE KKKsiazka_szczegoly
ROLLBACK
SELECT * FROM KKKsiazka_szczegoly
DELETE KKAutor WHERE (nazwisko = 'Mickiewicz')
DELETE KKKsiazka WHERE (tytul = 'Potop')