CREATE TABLE pes (cpsa char(4) PRIMARY KEY NOT NULL, jmeno varchar(15) NOT NULL, rasa varchar(15) NOT NULL, cena number, cklece char(4));
INSERT INTO pes (cpsa, jmeno, rasa, cena, cklece) VALUES ('A111', 'Ajax', 'NO', 5000, 'KL11');
INSERT INTO pes (cpsa, jmeno, rasa, cena, cklece) VALUES ('A222', 'Mojo', 'jezevcik', 3000, 'KL12');
INSERT INTO pes (cpsa, jmeno, rasa, cena, cklece) VALUES ('A333', 'Borek', 'kolie', 4000, 'KL13');
INSERT INTO pes (cpsa, jmeno, rasa, cena, cklece) VALUES ('A444', 'Azor', 'krizenec', 1, 'KL14');
INSERT INTO pes (cpsa, jmeno, rasa, cena, cklece) VALUES ('A555', 'Trhac', 'NO', 6000, 'KL15');

2]
SELECT jmeno AS "jmeno psa", cklece AS "cislo klece", cpsa AS "cislo psa", rasa, cena FROM pes WHERE cena > 3000;

3]
SELECT jmeno, rasa FROM pes WHERE jmeno LIKE '%x' OR jmeno LIKE '%k';

4]
SELECT jmeno, rasa FROM pes WHERE rasa = 'NO' OR rasa = 'jezevcik' OR rasa = 'kolie';

5]
CREATE TABLE klec (cklece char(4) PRIMARY KEY NOT NULL, kapacita numeric(2), typ varchar(15));
INSERT INTO klec (cklece, kapacita, typ) VALUES ('KL11', 1, 'zastresena');
INSERT INTO klec (cklece, kapacita, typ) VALUES ('KL12', 2, 'oplocena');
INSERT INTO klec (cklece, kapacita, typ) VALUES ('KL13', 3, 'volny vybeh');
INSERT INTO klec (cklece, kapacita, typ) VALUES ('KL14', 4, 'zastresena');
INSERT INTO klec (cklece, kapacita, typ) VALUES ('KL15', 5, 'oplocena');
INSERT INTO klec (cklece, kapacita, typ) VALUES ('KL16', 6, 'budnik');

6]
SELECT pes.jmeno, pes.rasa, pes.cena, klec.cklece, klec.kapacita FROM pes, klec WHERE pes.cklece = klec.cklece ORDER BY pes.jmeno;
# nebyl by lepsi join?

7]
SELECT klec.cklece, klec.kapacita FROM klec WHERE NOT EXISTS(SELECT cklece FROM pes WHERE pes.cklece = klec.cklece);


8]
CREATE TABLE nemectiovcaci AS SELECT * FROM pes WHERE rasa = 'NO';