How to display all employees name,job,salary,grade and depart name for every one in the company except ‘CLERK’.Sort on salary display the highest salary?

SELECT ename,
  job,
  dname,
  sal,
  grade
FROM emp,
  salgrade,
  dept
WHERE sal BETWEEN losal AND hisal
AND emp.deptno=dept.deptno
AND job NOT  IN(‘CLERK’)
ORDER BY sal ASC;