select top 3 "E".ename"姓名", "E".emp_sal"工资", "S".GRADE"等级", "D".dept_name"部门名字"
from emp"E"
join dept"D"
on "E".deptno = "D".deptno
join SAL"S"
on "E".emp_sal>=LOSAL and "E".emp_sal<=HISAL
where "E".ename not like '%K%' --这里为什么不能写在order by 后面
order BY "E".emp_sal desc