SQL - LEVEL2

51. display the name of emp who earns highest sal.

52. display the employee number and name of employee working as clerk and earning highest salary among clerks.

53. display the names of the salesman who earns a salary more than the highest salary of any clerk.

54. display the names of clerks who earn salary more than that of JAMES of that of sal lesser than that of scott.

55. display the names of employees who earn a sal more than that of james or that of salary greater than that of scott