Write a query to display the employee's number, name, job, Hiredate, and experiences (Working Years) of...

Transcribed Image Text:

Write a query to display the employee's number, name, job, Hiredate, and experiences (Working Years) of all MANGERS. 2. Write a query to display all the details of the employees whose commission is more than their salary. 3. Write a query to display the employees in the ascending order of designations of those joined after the first half of 1981. 4. Write a query to display the employees who are joined in the month of Feb 1981 5. Write a query to display the employees who Annual sal ranging from 22000 and 45000. 6. Write a query to display the employees who have Five character names starting with 'S' and ending with 'H'. 7. Write a query to display the employees who joined in June. 8. Write a query to display the employees who does not work in department number 30. 9. Write a query to display all employees except 'PRESIDENT' & 'MANAGER" in ascending order by Salaries. Write a query to display the employee's number, name, job, Hiredate, and experiences (Working Years) of all MANGERS. 2. Write a query to display all the details of the employees whose commission is more than their salary. 3. Write a query to display the employees in the ascending order of designations of those joined after the first half of 1981. 4. Write a query to display the employees who are joined in the month of Feb 1981 5. Write a query to display the employees who Annual sal ranging from 22000 and 45000. 6. Write a query to display the employees who have Five character names starting with 'S' and ending with 'H'. 7. Write a query to display the employees who joined in June. 8. Write a query to display the employees who does not work in department number 30. 9. Write a query to display all employees except 'PRESIDENT' & 'MANAGER" in ascending order by Salaries.

Answer rating: 100% (QA)

Task 1 sql SELECT employeenumber name job hiredate DATEDIFFCURDATE hiredate AS experiences FROM empl... View the full answer