SELECT * FROM zamestnanci

SELECT * FROM zamestnanci
ORDER BY plat 

SELECT * FROM zamestnanci
WHERE plat > 3000 DESC

//propojení tabulek + alias
SELECT jidlo.nazev, cena, kategorie.nazev AS kategorie FROM jidlo
INNER JOIN kategorie ON jidlo.id_kategorie = kategorie.id