Using SQL, solve the following queries based on the projects, employees. Workon, and rate tables discussed...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using SQL, solve the following queries based on the projects, employees. Workon, and rate tables discussed in the class (shown below). Note that the tables contain sample records only and do not represent all the possible records that could be stored in these tables. PROJECT_NUMBER 1 2 185 projects PROJECT_NAME PROJECT_CITY Eagle NY Super Jet LA 20 EMP_ID EMP_NAME 10 Smith 11 eSmith Smithe eSmithe workon PROJECT_NUMBER EMP_ID 1 10 1 11 10 20 11 2 2 2 employees RATE_CATEGORY EMP_CITY B NY SF LA SD BUO RATE_CATEGORY RATE A 100 80 60 50 rate D C C D 5. (2 Points) Find the average rate of the employees who work on project Eagle. 6. (2 Points) Find the names of the employees who work on more than one project. Display the results in descending order. Using SQL, solve the following queries based on the projects, employees. Workon, and rate tables discussed in the class (shown below). Note that the tables contain sample records only and do not represent all the possible records that could be stored in these tables. PROJECT_NUMBER 1 2 185 projects PROJECT_NAME PROJECT_CITY Eagle NY Super Jet LA 20 EMP_ID EMP_NAME 10 Smith 11 eSmith Smithe eSmithe workon PROJECT_NUMBER EMP_ID 1 10 1 11 10 20 11 2 2 2 employees RATE_CATEGORY EMP_CITY B NY SF LA SD BUO RATE_CATEGORY RATE A 100 80 60 50 rate D C C D 5. (2 Points) Find the average rate of the employees who work on project Eagle. 6. (2 Points) Find the names of the employees who work on more than one project. Display the results in descending order.
Expert Answer:
Answer rating: 100% (QA)
5 Find the average rate of the employees who work on ... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these databases questions
-
any ufacturing departments, Assembly and Painting. The Assembly department started 12,400 units during November. The following production activity in both units and costs refers to the Assembly...
-
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...
-
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...
-
You and Sam have been in touch since the Palm Beach Business Development Luncheon, and he has expressed interest in your working on his business audit. The two of you make plans to meet for lunch,...
-
A hole of radius is bored through a cylinder of radius R > r at right angles to the axis of the cylinder. Set up, but do not evaluate, an integral for the volume cut out.
-
On May 1, Year 1, Vladmir moved from Thompson, Manitoba, to Rocky Mountain House, Alberta, to start a job with Nuclear Inc.. As a result of the move, Nuclear provided Vladmir with a $4,680 moving...
-
You are faced with making a decision on a large capital investment proposal. The capital investment amount is $\$ 640,000$. Estimated annual revenue at the end of each year in the eight-year study...
-
Starbright Coffee Shop at the Galleria Mall serves two coffee blends it brews on a daily basis, Pomona and Coastal. Each is a blend of three high-quality coffees from Colombia, Kenya, and Indonesia....
-
Irna borrowed RM50,000 for her education purposes from PITIPITI Bank. The payments are to be made on an installment basis. The tenure of the loan is seven (7) years with 7 percent interest per annum....
-
1. a. How much did the materials cost per unit change between June and July? b. How much did the conversion cost per unit change between June and July? 2. Which is the optimal choice of material and...
-
Find the centroid (T, g) of the region bounded by: y = 6x? + 3x, y = 0, r = 0, and r = 5 Preview y= Preview Note: Answer exactly or round to 3 decimal places.
-
State the amount of revenue that should be recognised by Whitehall Ltd in the year ended 31 December 2020 for each item below, justifying your answer by reference to the revenue definition and...
-
Part A Branxton Ltds inventory on 1 April 2019 had a cost of $100 000 and a retail value of $170 000. During April, the companys net purchases cost $216 000 and had a net retail value of $324 000....
-
Your roommate is having difficulty understanding how a firm can keep operating despite losing money, earning a negative profit. How will firms respond to losing money?
-
Referring to the following spot and forward bid-ask rates for the US$/ exchange rate, answer the questions that follow: a. Is the euro at a premium or discount vis--vis the U.S. dollar? b. What is...
-
Cathys Consulting collected its latest bank statement on 1 July 2019. All entries appearing in the bank statement that had not been entered into the cash journals were entered therein. The cash...
-
Test 2 Mass transfer (open all 75 mins) (kelas pagi 52 mhs). Nama ......... A reactor in methanol plant produces a mixture with flow rate 1000 kgmol/hr and contain 75 mol % methanol and 25 mol %...
-
1. Below is depicted a graph G constructed by joining two opposite vertices of C12. Some authors call this a "theta graph" because it resembles the Greek letter 0. a. What is the total degree of this...
-
Why must service companies, even more so than manufacturing companies, focus on customer costs and profitability?
-
Financial budgets: cash inflows Worthington Company makes cash (20% of total sales), credit card (50% of total sales), and account (30% of total sales) sales. Credit card sales are collected in the...
-
What qualitative considerations are relevant in a make-or-buy decision?
-
Use subjective judgment to estimate the probability that the next time you ride an elevator, it gets stuck between floors.
-
Because it is impossible for Thanksgiving to fall on Tuesday, the probability of Thanksgiving falling on Tuesday is 0. For Exercises 510, decide whether the statement makes sense (or is clearly true)...
-
An insurance company states that the probability that a particular car will be involved in a car crash this year is 0.6 and the probability that the car will not be involved in a car crash this year...
Study smarter with the SolutionInn App