Question

33
3
Consider the table EMP(empno, ename, job, mgr, hiredate, sal, comm., deptno)
co Create a query to display name, job and salary for all employees whose job is Clerk or Anayst and their salary is
not equal to Rs. 1000, Rs. 3000, Rs. 5000
(c) Create a query to display the name and hiredate of every employee who was hired in 1982.
() Create a query to list the name and salary of employees who earn more than Rs. 1500 and are in department 10
or 30. Label the columns Employee and Monthly Salary respectively.​

Answer 1

Answer:

I hope you are understand