Reference no: EM13930361
(3.7) Write a SQL query that uses UNION of the two tables. Be creative.
Using the updated database, write the following queries using the SQL GROUP BY statement and appropriate aggregate
statements (when needed):
(3.8) Write a SQL query that displays the average salary / hourly wage grouped by job_title.
(3.9) Write a SQL query that displays the number of people in each EE0-1 Classification and the average salary / hourly wage
for each classification.
(3.10) Group employees by EEO classification: Select the employees' last names and group them by EEO-1 Classification
(3.11) Group employees by salary within their EEO classification: Select the employees' last names and group them by salary
within their EEO-1 Classification.
(3.12) Select the employees' last names and group them by salary within job titles that are grouped into exempt and
non-exempt.
Using the database and tables from Week Three, write queries to the specifications listed below.
(Note: Verify that the updates in the next three statements (4.1 - 4.3) are completed correctly by displaying the relevant
columns before and after the updates run.)
(4.1) Choose an EEO-1 Classification: Increase all employees' salaries that have: the selected EEO-1 classification by 10%.
(4.2) Increase all employees' salaries by 5%.
(4.3) Choose an employee from the employee table; delete this employee.
Using the database and tables from Week Three, write SQL statements to:
(4.4) How many people are salaried and how many are hourly?
(4.5) Calculate the minimum salary for all salaried employees.
(4.6) Calculate the minimum hourly rate for all hourly employees.
(4.7) Calculate the average wage (salaried or hourly) for each EEO-1 Classification.
(4.8) Calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees.
(4.9) Calculate the minimum salary for exempt employees and the maximum salary for non-exempt employees.
Attachment:- 2-Gear-IA.zip
Attachment:- 3-Gear-IA.zip
Portfolio and for a market index
: In contrast, Consultant 2 report annual Sharpe Ratios of 0.41 and 0.40 for Mr. Smith's portfolio and for a market index, respectively, and an annual CAPM alpha of 0.12%. Can both consultants have correct calculations? Explain in detail.
|
What is the price of the option
: Consider an option on a non-dividend-paying stock when the stock price is $30, the exercise price is $29, the risk-free interest rate is 5% per annum, the volatility is 25% per annum, and the time to maturity is four months. a) What is the price o..
|
Determine the angle through which the wheel may be turned
: Determine the angle through which the wheel may be slowly turned about its horizontal axis through O, starting from the position shown, before the rod begins to slip.
|
Implications of sontag''s claim for contemporary politics
: ‘The problem is not that people remember through photographs, but that they remember only photographs. Discuss the implications of Sontag's claim for contemporary politics and humanitarian organisations
|
How many people are salaried and how many are hourly
: Choose an employee from the employee table; delete this employee.
|
Essay about short story - the gift of the magi
: Write an analytical essay about the short story about ,"the gift of the magi" and the critique, "the secret gift",by Ted Gup. Find the thesis/topic in the book and the critique. Do not compare or contrast or agree. JUST analyze the two texts
|
Describe any unintended consequences or behaviors
: Describe any unintended consequences or behaviors that might arise when using this method of behavior change, and how you might plan for these unintended changes ahead of time.
|
Determining the statements of cash flows
: Following are statements of cash flows for Byron Ltd for the years ended 31 December:
|
Find the confidence interval on downtime
: What does the confidence level determine (in simple terms)? Determine the a risk for each of the confidence levels below. Find the confidence interval on downtime.
|