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

SELECT jidlo.nazev, cena, kategorie.nazev FROM jidlo 

SELECT * FROM jidlo WHERE nazev LIKE 'P%'

WHERE nazev LIKE '%pizza%'

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

DELETE FROM zamestnanci WHERE id = 8;