т. 5.7 SELECT slujiteli.id, slujiteli.ime, trudovstaj.zaplata, trudovstaj.trudovstaj FROM slujiteli INNER JOIN trudovstaj ON slujiteli.id = trudovstaj.ID WHERE (trudovstaj.trudovstaj < 10) AND (trudovstaj.zaplata > 270) ORDER BY slujiteli.ime ASC
Правила