SELECT * FROM zamestnanci SELECT * FROM zamestnanci ORDER BY plat DESC SELECT * FROM zamestnanci WHERE plat > 50000 SELECT * FROM zamestnanci WHERE plat < 50000 ORDER BY plat DESC INNER JOIN kategorie ON jidlo.id_kategorie = kategorie.id SELECT jidlo.nazev, cena, kategorie.nazev FROM jidlo INNER JOIN kategorie ON jidlo.id_kategorie = kategorie.id SELECT jidlo.nazev, cena, kategorie.nazev AS kategorie FROM jidlo INNER JOIN kategorie ON jidlo.id_kategorie = kategorie.id SELECT * FROM jidlo WHERE nazev LIKE "%pizza%"