.Write a query to update the employees salaries, who are working as REP on the basis...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
.Write a query to update the employees salaries, who are working as REP on the basis of 22 percentage (22%). .Write a query to list out the department ID having at least three employees. . Write a query to delete the employees who are working in Public Relations department. . Write a query to show the Nth highest salary drawing employee details show job ID for jobs with average salary less than 15600. Write a query to show departments in which more than six employees have commission pct. . Write a query to show employee ID for employees who have done more than one job in the past. . Write a query to show the job ID of jobs that have been completed for more than 80 days by more than three employees. .Write a query to show department ID, year, and no. of employees joined. Write a query to show departments where any manager is managing less than four employees. Write a query to change salary of employee 115 to 9500 if the existing salary is less than 7500. . Write a query to insert a new employee into employees with all the required information. : Write a query to delete departments 40 and 240. . Write a query to change job ID of employee 177 to CLERK if the employee belongs to department 80 and the existing job ID does not start with SH. . Write a query to insert a row into departments table with manager ID 120 and location ID in any location ID for city Switzerland. PART 1 NOTE// PLEASE USE ORACLE 10g SOFTWARE DATABASE TO ANSWER THE QUESTION AND GET GIVEN TABLES FROM IT. .Write a query to update the employees salaries, who are working as REP on the basis of 22 percentage (22%). .Write a query to list out the department ID having at least three employees. . Write a query to delete the employees who are working in Public Relations department. . Write a query to show the Nth highest salary drawing employee details show job ID for jobs with average salary less than 15600. Write a query to show departments in which more than six employees have commission pct. . Write a query to show employee ID for employees who have done more than one job in the past. . Write a query to show the job ID of jobs that have been completed for more than 80 days by more than three employees. .Write a query to show department ID, year, and no. of employees joined. Write a query to show departments where any manager is managing less than four employees. Write a query to change salary of employee 115 to 9500 if the existing salary is less than 7500. . Write a query to insert a new employee into employees with all the required information. : Write a query to delete departments 40 and 240. . Write a query to change job ID of employee 177 to CLERK if the employee belongs to department 80 and the existing job ID does not start with SH. . Write a query to insert a row into departments table with manager ID 120 and location ID in any location ID for city Switzerland. PART 1 NOTE// PLEASE USE ORACLE 10g SOFTWARE DATABASE TO ANSWER THE QUESTION AND GET GIVEN TABLES FROM IT.
Expert Answer:
Answer rating: 100% (QA)
1 Update employees salaries who are working as REP on the basis of 22 sql UPDATE employees SET salary salary 122 WHERE jobid REP 2 List department IDs ... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
Martinez Company's relevant range of production is 7,500 units to 12,500 units. When it produces and sells 10,000 units, its average costs per unit are as follows: Average Cost per Unit Direct...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...
-
In a survey of 1,002 people, 701 (or 70%) said that they voted in the last presidential election (based on data from ICR Research Group). The margin of error was 3 percentage points. However, actual...
-
Knowing that the figure shown is formed of a thin homogeneous wire, determine the length l of portion CE of the wire for which the center of gravity of the figure is located at point C when (a)...
-
Discuss aspects of number theory related to prime numbers and discrete logarithms ?
-
A mutual fund has provided investment yield rates for five consecutive years as follows: Determine \(r_{1}\) and \(r_{2}\), the lag 1 and lag 2 autocorrelation coefficients. Determine \(r_{1}\) and...
-
A partial work sheet for Jim Jacobs' Furniture Repair is shown as follows. Indicate by letters (a) through (d) the four adjustments in the Adjustments columns of the work sheet, properly matching...
-
Orca Industries Below are the two most recent balance sheets and most recent income statement for Orca Industries. The company has an effective tax rate of 3 0 % . Balance Sheet Year 1 Year 0 Assets:...
-
Barone, Inc. is involved with several situations that possibly involve contingencies. Each is described below. Barone's fiscal year ends December 31, and the 2021 financial statements are issued on...
-
A pizza company produces frozen pizzas in three departments: assembly, freezing, and packaging. In assembly, crust ingredient are added at the beginning of the process. After the crust is made, the...
-
True Or False Under the common law a husband and wife were considered one entity.
-
What is a plaintiff alleging malpractice required to prove?
-
True Or False Assumption of risk completely bars the plaintiff from recovery in most modern courts.
-
True Or False Attorneys are held to a general standard of care even if they are certified specialists.
-
True Or False In assigning a percentage of fault to a plaintiffs conduct, one considers the extent to which that conduct contributed to the resulting harm or the extent to which it deviated from a...
-
1. Which formula is typically used to describe the components ofinformation security risks? A) Risk = Likelihood X Vulnerability B) Risk = Threat X Vulnerability C) Risk = Threat X Likelihood D) Risk...
-
Splitting hairs, if you shine a beam of colored light to a friend above in a high tower, will the color of light your friend receives be the same color you send? Explain.
-
Kitimat Co. mines and produces aluminum. During 2018, the company explored two new sites and evaluated them for aluminum ore potential. By the year ended December 31, 2018, the sites remained in the...
-
Acorn Mines began developing an open pit copper and zinc mine in northern Ontario in April of 2014. As part of the regulatory approvals to develop and to extract minerals from the site, the company...
-
Evans Shielding Products (ESP) uses the aging method for its accounts receivable. On January 1, 2017, the balance in the allowance for doubtful accounts was $20,000. For the year ended December 31,...
-
The magical elevator. There is a man who lives on the top floor of a very tall building. Every day he gets the elevator down to the ground floor to leave the building to go to work. Upon returning...
-
A murderer is condemned to death. He has to choose between three rooms. The first is full of raging fires, the second is full of assassins with loaded guns, and the third is full of lions that havent...
-
Five pieces of coal, a carrot, and a scarf are lying on the lawn. Nobody put them on the lawn, but there is a perfectly logical reason they should be there. What happened? How do you explain this?
Study smarter with the SolutionInn App