Question: Using the EMPLOYEES and JOBS tables, write a query which displays data (name, salary, and total pay) for all employees with a job title that

Using the EMPLOYEES and JOBS tables, write a query which displays data (name, salary, and total pay) for all employees with a job title that includes the string 'Manager '. Use the following specifications for the 4 columns:

1. employee name using the format J Smith, A Doe, M Goon, etc. with first initial and last names displayed as one column with a space between firs and last name using the column alias "Full Name". Use mixed case as shown.

2. employee's salary

3. employee's commission percent

4. employee's total pay which includes both the salary and any commission earned (add together their salary and their earned commission) using the column alias "Total Pay". The commission value in the table is a percentage of their salary, so multiply this percentage by each employee's salary to determine their commission amount - then add to their salary value. Round this value to 2 decimal places.

Step by Step Solution

★★★★★

3.46 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

You can use the following SQL query to display data for all employees with a job title that incl... 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!

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Gaines Company recently initiated a postaudit program. To motivate employees to take the program seriously, Gaines established a bonus program. Managers receive a bonus equal to 10 percent of the...

This exercise continues the Lawlor Lawn Service, Inc., situation from Exercise 9-39 of Chapter 9. Refer to the Chapter 2 data for Exercise 2-61. Lawlor Lawn Service, Inc., is considering hiring its...

Compare the advantages and disadvantages of using spot checks/hidden video cameras in the workplace and pay-for-performance pay schemes as means to influence worker performance.

On February 5, Devon entered into a written agreement with Gordon whereby Gordon agreed to drill a well on Devons property for the sum of $5,000 and to complete the well on or before April 15. Before...

On January 24, 1994, Frederick Hantske Jr. was telephoned at home by Paul Kallina, an employee of Brandenburger & Davis, Inc. Kallina told Hantske that he could possibly be an heir to an estate and...

Various Receivable Accounting Issues Kimmel Company uses the net method of accounting for sales discounts. Kimmel also offers trade discounts to various groups of buyers. On August 1, 2010, Kimmel...

Using the table in Figure on pages 286 and 287, determine the amount of federal income tax an employer should withhold weekly for employees with the following marital status, earnings, and...

Marathon Running Shop has two service departments (advertising and administration) and two operating departments (shoes and clothing). During 2013, the departments had the following direct expenses...

Welland Fabricating borrowed $73,400 at 8% compounded quarterly to purchase a new piece of machinery. Payments of $5000 are made at the end of every 3 months How much is the final loan payment? (Do...

Differentiate the function. F ( s ) = l n ( l n ( 8 s ) ) F ' ( s ) = 1 s i n ( 8 s )

identify for the activity cost driver that will incurred when the company make the pencil and give your explanation or justification for each activity cost driver that you identified. The activities...

For the year ending December 31, 2019, Hughes Ltd. has Taxable Income, before consideration of dividends or salary paid to its sole shareholder, of $175,000. The Companys cash balance is over...

A customer applying for a personal auto policy should always receive a standard confirmation letter, informing them that the policy is being prepared, and should be ready in less than a week. When...

Create select queries for What SUP using comparison operators. (Use the Ch11-02 student file, or use the file you used in answering the previous question.) a. Create and print a select query that...

When might you use a delete query?

The Wine Depot is contemplating several alternative means of financing their annual acquisition of $70,000 in equipment. One option is to borrow $300,000 from a local bank for 5 years at 11 percent...

By calculating the maturity value of $100 invested for one year at each rate, determine which rate of return an investor would prefer. a. 12.0% compounded monthly b. 12.1% compounded quarterly c....

What is the maturity value of a $12,000 loan for 18 months at 7.2% compounded quarterly? How much interest is charged on the loan?

What is the future value of $8500 after 5 years if it earns 9.5% compounded quarterly?