SELECT * FROM kniha
SELECT meno, priezvisko,id, nazov FROM kniha
SELECT nazov, cena, vydavatel FROM kniha WHERE vydavatel = "Spisovatel"
SELECT nazov, cena, vydavatel FROM kniha WHERE vydavatel <> "Spisovatel"
SELECT nazov, cena, vydavatel FROM kniha WHERE nazov like"%Linux%"
SELECT nazov, cena, vydavatel FROM kniha WHERE nazov matches"%LInux%"
SELECT nazov, cena, vydavatel FROM kniha WHERE cena = 332
SELECT nazov, cena, vydavatel FROM kniha WHERE cena < 332
SELECT nazov, cena, vydavatel FROM kniha WHERE cena > 332
SELECT nazov, cena, vydavatel FROM kniha WHERE cena <> 332

SELECT * FROM kniha WHERE cis_odd = 6 AND cena > 300
SELECT * FROM kniha WHERE vydavatel="Spisovatel" OR vydavatel="Vydavatelstvo"
SELECT * FROM kniha WHERE vydavatel NOT "Spisovatel"
SELECT * FROM kniha WHERE cena BETWEEN 100 AND 900

SELECT * FROM kniha LIMIT 5
SELECT * FROM kniha LIMIT 5,10

SELECT * FROM kniha ORDER BY meno
SELECT * FROM kniha ORDER BY cena DESC
SELECT * FROM kniha ORDER BY cena asc

SELECT nazvy stlpcov, agregacna funkcia FROM meno_tabulky GROUP BY nazov_stlpca_k_zoskupeniu
SELECT cis_odd, sum(cena) AS 'Celkom' FROM kniha GROUP BY cis_odd
SELECT nazvy stlpcov, agregacna funkcia FROM meno_tabulky GROUP BY nazov_stlpca HAVING sum(cena)>200

SELECT min(cena) AS 'Minimalna cena', max(cena) AS 'Maximalna cena' FROM kniha
SELECT avg(cena) AS 'Priemerna cena' FROM kniha
SELECT count(*) AS 'Pocet kniha' FROM kniha

SELECT c.customer_num, c.lname, c.company, c.phone, u.call_dtime, u.call_descr 
FROM custome c, cust_calls u 
WHERE c.customer_num = u.customer_num

SELECT c.customer_num, c.lname, c.company, c.phone, u.call_dtime, u.call_descr 
FROM customer c OUTER cust_calls u
WHERE c.customer_num = u.customer_num

SELECT c.customer_num, c.lname, o.order_num, i.stock_num, i.manu_code, i.qaunntity
FROM customer c OUTER(order o, items i)
WHERE c.cutomer_num = o.customer_num 
AND o.order_num = i.order_num AND manu_code IN('KAR','SHM')
ORDER BY lname

SELECT c.customer, lname, o.order_num, order_date, call_dtime
FROM customer c, outer orders o, outer cust_calls x
WHERE c.customer_num = o.customer_num 
AND c.customer_num = x.customer_num ORDER BY lname
INTO TEMP service

(vypis nazvy stud_prog, a pocet kolko maju predmetov takych ze kredit je 2)
SELECT sp.nazov, count(kod_predmetu)
FROM studijny_program sp, tabulka t, predmet p
WHERE t.kod_predmetu = p.kod_predmetu 
AND t.kod_sp = sp.kod_sp
AND p.kod_predmetu IN(SELECT kod_predmetu FROM predmet WHERE kredity=2)
GROUP BY sp.nazov

