SELECT * FROM zamestnanci

SELECT * FROM zamestnanci ORDER BY prijmeni

SELECT * FROM zamestnanci ORDER BY prijmeni DESC

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 jidlo.nazev, cena, kategorie.nazev AS kategorie 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ý', '1997', '1000');
INSERT INTO `zamestnanci` (jmeno, prijmeni, narozeni, plat) VALUES ('Pavel', 'Svatý', 1997, 1000);

UPDATE zamestnanci SET plat = 200000 WHERE id = 6;
UPDATE zamestnanci SET plat = 1.1*plat;

DELETE FROM zamestnanci WHERE id = 7;