SELECT * FROM zamestnanci

SELECT * FROM zamestnanci ORDER BY plat DESC

SELECT * FROM zamestnanci WHERE plat > 40000

SELECT * FROM zamestnanci WHERE plat < 50000 ORDER BY plat DESC

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