SELECT * FROM jidlo
INNER JOIN kategorie 
ON jidlo.id_kategorie = kategorie.id 
ORDER BY cena

SELECT jidlo.nazev, cena, kategorie.nazev FROM jidlo 

SELECT * FROM jidlo WHERE nazev LIKE 'P%'

WHERE nazev LIKE '%pizza%'