SELECT * FROM zamestnanci

SELECT * FROM zamestnanci ORDER BY prijmeni

SELECT * FROM zamestnanci WHERE id > 2

SELECT * FROM zamestnanci WHERE id > 2 ORDER BY prijmeni

SELECT * FROM jidlo 
INNER JOIN kategorie ON jidlo.id_kategorie = kategorie.id
ORDER BY cena

SELECT jidlo.nazev, cena, kategorie.nazev FROM jidlo 
INNER JOIN kategorie ON jidlo.id_kategorie = kategorie.id
ORDER BY cena

SELECT * FROM jidlo
WHERE nazev LIKE '%pizza%'

INSERT INTO `zamestnanci` (`jmeno`, `prijmeni`, `narozeni`, `plat`)
VALUES ('Pavel', 'Svatý', '2001', '10');

INSERT INTO zamestnanci (jmeno, prijmeni, narozeni, plat)
VALUES ('Petr', 'Svatý', 2001, 20);



UPDATE zamestnanci SET plat = 200000 WHERE id = 6;

UPDATE zamestnanci SET plat = 1.1*plat;

UPDATE zamestnanci SET
jmeno = 'Adam', prijmeni = 'Rajský', narozeni = 1999, plat = 100000
WHERE id = 6;


DELETE FROM zamestnanci WHERE id = 8;