Answered step by step
Verified Expert Solution
Question
1 Approved Answer
sql 1. Write a query to display the employee's number, name, job, Hiredate, and experiences (Working Years) of all MANGERS. 2. Write a query to
sql
1. 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 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started