Calculate a bonus depending on job id using a case expression. Display the employee id, last name, job id, department id, salary, and the bonus amount • If job id is AD_VP, the bonus amount will be Salary * .1555 • If job id is IT_PROG, the bonus amount will be Salary * .1050 • For all other job roles, the bonus amount will be 50.00 dollars. Name the column bonus amount and round the values to a whole number (0 decimal places).

Calculate a bonus depending on job id using a case expression. Display the employee id, last name, job id, department id, salary, and the bonus amount • If job id is AD_VP, the bonus amount will be Salary * .1555 • If job id is IT_PROG, the bonus amount will be Salary * .1050 • For all other job roles, the bonus amount will be 50.00 dollars. Name the column bonus amount and round the values to a whole number (0 decimal places).

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter10: Selected Single-row Functions

Section: Chapter Questions

Problem 8HOA

See similar textbooks

Similar questions

Write a Select statement that returns the Trading_Symbol column and the Num_Shares column only from the rows where Selling_Price is greater than Purchase_Price and Num_Shares is greater than 100. The results should be sorted bythe Num_Shares column in ascending order.
Assume the PRODUCT table contains multiple rows. The following code would include: SELECT P_DESCRIPT, P_PRICE, AVG(P_PRICE) AS AVGPRICE FROM PRODUCT WHERE P_PRICE > AVGPRICE; Group of answer choices A) An error message. B) Show all whose standard price is no less than the average price of all products. C) Show all whose standard price is no less than the average price of some products. D) Show all whose standard price is higher than the average price of all products.
7-Display last name of employees whose manager is KING.8-Display last name, salary and job title of all employees who earns more than the lowest salary. (Employees andJobs)9-Display all employees including King, who has no manager. Order the results by the employee number.10-Display the name and hire date of any employee hired after employee Davis
The ITEM table contains the following columns statement. Analyze the statement why it will fail during execution. ITEM ID NUMBER(9) VARCHAR2(20) NUMBER(5,2) VARCHAR2(10) NUMBER(5) SELECT NVL (100 / AMOUNT, “NONE") FROM ITEM; ITEM NAME BUY PRICE BRAND ID AMOUNT
Q :Draw a flow chart for Grade calculation. i :Refer to undergraduate prospectus
Based on the ERD below, display the first name, last name and employee initial of anyone whose first name starts with “A”. (Hint: You will use a “Like” phrase.)
you are supposed to create an excel sheet for student grade sheet. There must be at least 10 records. Following columns will be needed for the sheet. Also add summary of the grades as follows. Grade Count A 6 B 4 C 8 D 2 F 10 TOTAL 30 Grading Criteria to calculate grades is as follows: Marks Grade 90-100 A 80-89 A- 75-79 B+ 70-74 B 65-69 C+ 60-64 C 50-59 D Less than 50 F
Question 3 Below code intends to use a variable grade to store a set of grades. Explain what is the syntax error and how to get it fixed. Only one line of code can be changed with other lines still being used. grade = (90,) grade.append(80) grade.append(70) grade.append(85) # syntax error: # how to fix: What sequence type you should use to create a look-up table between the following departments and colleges? The science college has departments of geo, bio; the Arts college has departments of anth, history. Complete the code so that the code will print out the college where the geo department is in. #Sequence type: dept2col= "geo":"science", "bio":"science", "anth":"Arts", "history":"Arts" print dept2col Which of the following statements are correct? O ArcPy data access module has been avaíable since ArcGIS 10.1 O ArcPy data access module has been avaiable since ArcGIS 10.o. O ArcPy data access module offers a cursor with faster access to data. O The cursor in data access module is the…
Don't want copy paste answer
A boxplot shows the value 31 at the first quartile. What does this tell you? Question 3 options: 31% of the data is less than 25. 75% of the data is less than 31. 25% of the data is greater than 31. 31% of the data is greater than 25. 25% of the data is less than 31. Group A has a mean of 0 and a median of 15 What is most likely true? Question 8 options: Group A likely has a high outlier or right skew Group A is likely roughly symmetric and unimodal Group A likely has a low outlier or left skew Group A likely has low and high outliers. None of these
Assume the PRODUCT table contains multiple rows. The following code would include: SELECT P_DESCRIPT, P_PRICE FROM PRODUCT WHERE P_CODE IN(SELECT P_CODE FROM LINE GROUP BY P_CODE HAVING COUNT(*) > 1); Group of answer choices A) Select the products that have been ordered before. B) Select the products that have been ordered at least once. C) Select the products that have been ordered at least twice. D) An error message.
With the following table: PRODUCTS(PRODUCT_NUMBER, DESCRIPTION,PURCHASE_DATE,CATEGORY) Write the mySQL statement that will insert the following PRODUCT into the table: PRODUCT_NUMBER: ‘67832’ DESCRIPTION: ‘KRAZY CAT CEREAL’ PURCHASE_DATE: 2023-11-14 CATEGORY: ‘CPG’ Write the mySQL statement that will insert that product but without a description.