SELECT * FROM zamestnanci

SELECT * FROM zamestnanci 
ORDER BY plat DESC

SELECT * FROM zamestnanci
WHERE plat > 50000

// nejdriv se dava podminka, potom razeni
SELECT * FROM zamestnanci
WHERE plat < 50000
ORDER BY plat DESC

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