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

SELECT nazev, cena, id_kategorie FROM jidlo
// propojeni tabulek + alias
SELECT jidlo.nazev, cena, kategorie.nazev FROM jidlo
INNER JOIN kategorie ON jidlo.id_kategorie = kategorie.id;