Question: 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

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

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

1 Expert Approved Answer

Step: 1 Unlock

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

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Define and explain Starbucks also explain standard leadership model. What revisions need to be made to the vision and mission statements for Starbucks and Whole Foods Market practicing a standard...

Write a query to display the employee number, last name, first name, salary from date, salary end date, and salary amount for employees 83731, 83745, and 84039. Sort the output by employee number and...

How would you define behavioral learning? Explain How would you define cognitive learning? Explain Also List an example for both.

Write a query to display the employee number, last name, first name, department name and department address for employees number 103, 160, 195 and 297. Sort the output by employee number and last...

Looking for 5.1-5.10 5. Create Queries that to do the following: (10 marki). Your queries will be marked based on whether the queries are formulated correct or not, net based on the records that are...

Question 25 Write a query that returns the employee ID, last name, and the employees region ID and region description. Choose the best query solution. SELECT Distinct Employees.EmployeeID ,...

About the Database A company resells paints to customers both individual and company customers, but same data is recorded for both. The company tracks the sale of products to customers and the...

Write a query to display the name, department number, and department name for all employees. Create a unique listing of all jobs that are in department 30. Include the location of the department 30...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql 30. Write a query to display the first name, last...

SQL CODE: 30. Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title "CLERK I." Sort the output by...

COLLEGE OF ENGINEERING & TECHNOLOGY Department Electronics and Communications Engineering Dept. Lecturer Course Name Dr. Samh A. Fathy Electronics I Course Code EC238 Time allowed: 50 min Date...

Adele, age 24, was recently diagnosed with cancer. This form of cancer is treatable, requiring several months' worth of hospital treatments. She feels a great deal of stress from being diagnosed with...

Find the derivative of the function. g ( x ) = x on top and - 5 on bottom. 1 / t ^ 2 + 4 dt

Marston Manufacturing has an annual capacity of 85,000 units per year. Currently, the company is making and selling 78,000 units a year. The normal sales price is $120 per unit, variable costs are...

Braxton Technologies, Inc., constructed a conveyor for A&G Warehousers that was completed and ready for use on January 1, 2018. A&G paid for the conveyor by issuing a $100,000, four-year note that...

Techno Inc. intends to invest in one of two competing types of flexible manufacturing systems: FLEX-1K and FLEX-2Z. Both systems have a project life of 10 years. The purchase price of the FLEX-1K...

On January 1, 2006 the Sato Company adopted the dollar-value LIFO method of inventory costing. The company's ending inventory records appear as follows: Required Compute the ending inventory for the...

Cash Flows of a government must be presented in four categories, rather than the three used by businesses. The following list of cash flows was taken from the statement of cash flows of Grand...

It is important to design recruitment efforts in such a way thatthey yield only job applicants with formal education and past job experiencesthey yield job applicants who have at least the minimum...

What is the objective of the query optimization functions?

The dependency diagram in Figure indicates that authors are paid royalties for each book that they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of the...

What is connectivity? (Use a Crows Foot ERD to illustrate connectivity.)

Why is media selection a critical part of the marketing managers job?

Try to explain the nature of a corporate personality. Why is this significant for marketing communication?

How does marketing communication impact upon brand name?