SELECT * FROM zamestnanci

SELECT * FROM zamestnanci ORDER BY plat

SELECT * FROM zamestnanci WHERE plat > 40000

SELECT * FROM zamestnanci WHERE plat > 40000 ORDER BY plat DESC

INNER JOIN kategorie ON jidlo.id_kategorie = kategorie.id

INSERT INTO zamestnanci (jmeno, prijmeni, narozeni, plat)
VALUES ('Diego', 'Maradona', 2000, 10);

UPDATE zamestnanci SET
plat = 200000
WHERE id = 8;

DELETE FROM zamestnanci
WHERE id = 9