Question
Questions: Compate the amount to be billed to each project is Amount. The amount for each project is computed as the sam of the amouet
Questions:\ Compate the amount to be billed to each project is "Amount". The amount for each project is computed as the sam of the amouet billed to the project by all employees working on the project. The amount billed by an employee to n project is obtsined as the product the hours (HRS) that the employee devoses to the project and the billing rate (E_RATE) for the employee (show only the output of the guery).\ Compute the total teverae generated by each department as "Revenue". The Revenue for each department is computed as the sam of the amount billed to all projocts controlled by the departiment. (Note that the PR DEPT for a project represents the controlling department for the project) (show only the cutput of the query).\ List the names of employees who only work in projects losated (PR_LOC) in New York (NY) (show ouly the catpat of the query).\ List the name of employees who work on all projets (show only the output of the query).\ List the project numbers (PR NO) for projects that have only received ports that sire stored in (P_CITY) the same city as the project (ahow obly the outgut of the query).
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