select s.grade, e.ename, d.dname, 0.15*e.sal as "prima"

from dept d, emp e, salgrade s

where (e.comm is NULL or e.comm = 0)

and e.sal between s.losal and s.hisal

and d.deptno = e.deptno

order by 1 desc,4 asc;