select * from zamestnanci

order by plat desc

where plat > 50000

select jidlo.nazev, cena, kategorie.nazev as kategorie from jidlo
inner join kategorie on jidlo.id_kategorie = kategorie.id


INSERT INTO `zamestnanci` (jmeno, prijmeni, narozeni, plat)
VALUES ('Hugo', 'Boss', '1999', '0');

UPDATE `zamestnanci` SET
plat = 200000
WHERE `id` = '8';