.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...
-
World Airlines has three service departments: (1) ticketing, (2) baggage handling, and (3) engine maintenance. The service department costs are estimated for separate cost pools formed by department...
-
It is common in Malaysian culture for people to value teamwork and to display great respect for authority. Hofstede would describe this culture as high in both ____________. (a) uncertainty avoidance...
-
Are fraudulent financial statements a great problem in government units?
-
Amanda M is a regional manufacturer and wholesaler of high-quality chocolate candies. The companys sales and collection process is as follows. Amanda M makes use of an enterprise-wide information...
-
The common stocks of DEF Inc. currently sell for P38. There is a call option on this stock with an exercise (strike) price of P40. At the end of year 1, there is a 50% chance that the price will be...
-
On January 1, 2021, the general ledger of Grand Finale Fireworks includes the following account balances: During January 2021, the following transactions occur: January 2 Issue an additional 2,000...
-
The controller for Tulsa Medical Supply Company has established the following activity cost pools and cost drivers. Budgeted Overhead Activity Cost Pool Cost Cost Driver Budgeted Level for Cost...
-
Using feedback is an important part of the writing process. Through feedback, writers have conversations which provide encouragement and suggestions on their colleagues' work. you'll begin an ongoing...
-
Thomas recently signed an agreement for a serverless computing environment where his organization's developers will be able to write functions in Python and deploy them on the cloud provider's...
-
Assume that actual sales for the month total $ 7 5 0 , 0 0 0 as planned; however, actual sales by product are: White, $ 3 0 0 , 0 0 0 ; Fragrant, $ 1 8 0 , 0 0 0 ; and Loonzain, $ 2 7 0 , 0 0 0 ....
-
My chosen project is Beat the Clock: Time Management Training Can Improve Productivity and Morale by Helping Employees Balance Work and Family byKathryn Tyler Address the following items, which will...
-
A gas station owner finds that for every penny increase in the price of gasoline, she sells 1657 fewer gallons per week. Using x to represent the number of penny changes in price, create an equation...
-
Previous Page Next Page Page 8 of 18 Question 8 (11 points) Listen Ms. A acquires a residential property on May 1, 2023 (i.e. this property is a new property for her). The total cost of the property...
-
Nate prepares slides for his microscope. In 1 day he prepared 12 different slides. Which equation best represents y, the total number of slides Nate prepares in x days if he continues at this rate? A...
-
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,...
-
\(\frac{11^{3}}{11^{7}}\) Simplify the expression.
-
\(\frac{a^{14}}{a^{5}}\) Simplify the expression.
-
\(\frac{7^{14}}{7^{23}}\) Simplify the expression.
Study smarter with the SolutionInn App