SELECT ASSIGN_NUM, EMP_NUM, PROJ_NUM, ASSIGN_CHARGE, ASSIGN_CHG_HR * ASSIGN_HOURS AS CALC_ASSIGN_CHARGE FROM ASSIGNMENT ORDER BY ASSIGN_NUM; This is a sample of some MySQL code that I need to use to answer a question. However, the automated grading system isn't accepting this as the full answer because this results in answers that don't round to the second decimal place in the CALC_ASSIGN_CHARGE portion. What do I need to do to make it so it does result in something rounded to the nearest second decimal place?

SELECT ASSIGN_NUM, EMP_NUM, PROJ_NUM, ASSIGN_CHARGE, ASSIGN_CHG_HR * ASSIGN_HOURS AS CALC_ASSIGN_CHARGE FROM ASSIGNMENT ORDER BY ASSIGN_NUM; This is a sample of some MySQL code that I need to use to answer a question. However, the automated grading system isn't accepting this as the full answer because this results in answers that don't round to the second decimal place in the CALC_ASSIGN_CHARGE portion. What do I need to do to make it so it does result in something rounded to the nearest second decimal place?

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter4: The Selection Structure

Section: Chapter Questions

Problem 1MQ4

See similar textbooks

Similar questions

I get the error below when I try to create this procedure. It should be in MYSQL. Is my syntax for MYSQL wrong? CREATE PROCEDURE PRC_INV_AMOUNTS (W_IN IN NUMBER) W_CHK NUMBER = 0; W_SUBT NUMBER = 0; W_TAX NUMBER = 0; SELECT COUNT(*) INTO W_CHK FROM INVOICE WHERE INV_NUMBER = W_IN; IF W_CHK = 1 THEN SELECT SUM(LINE_TOTAL) INTO W_SUBT FROM LINE WHERE LINE.INV_NUMBER = W_IN; W_TAX := W_SUBT * 0.08; UPDATE INVOICE SET INV_SUBTOTAL = W_SUBT, INV_TAX = W_TAX, INV_TOTAL = W_SUBT + W_TAX WHERE INV_NUMBER = W_IN; END IF; END; ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN NUMBER) W_CHK NUMBER = "0", W_SUBT NUMBER = "0", W_TAX NUMBER = "0" SELECT C' at line 1 The original problem asks for MYSQL code to Create a stored procedure named prc_inv_amounts to update the INV_SUBTOTAL, INV_TAX, and INV_TOTAL. The procedure takes the invoice number as a parameter. The…
What is the result of the query below: SELECT V_CODE, COUNT (P_CODE) FROM PRODUCT HAVING V_CODE != 21344; A) A list of V_CODE, and the number of products for each V_CODE that is equal to 21344. B) An error message. C) A list of V_CODE, and the number of products for each V_CODE that is not equal to 21344. D) The number of counts for each P_CODE that has a V_CODE that is not equal to 21344.
What will be the result of the following Statement? SELECT MOD(LENGTH(Student_NAME), 2) FROM Students Where student_name like '%a’ and DOB between '01-Jan-1991' and '01-Jan-1997'; There are four coding errors in the following statement. Identify them. Select Concat(StudentID || StudentName) as "student details" , To_char(DOB,”mm”) Birth_Month From Student Where StudentName like 'S*' and Department IN ('D103' or 'D102');
MySQL Workbench Will the following select statements work? If the queries don’t work, explain why and then correct them.a-) SELECT NAME, EMPLOYEE_ID, SALARYFROM EMPLOYEE_TBL E, EMPLOYEE_PAY_TBL EPWHERE EMPLOYEE_ID = EMPLOYEE_ID AND NAME LIKE '%MITH';b-) SELECT E.NAME, E.EMPLOYEE_ID, EP.SALARYFROM EMPLOYEE_TBL E, EMPLOYEE_PAY_TBL EPWHERE NAME LIKE '%MITH';c-) SELECT E.NAME, E.EMPLOYEE_ID, EP.SALARYFROM EMPLOYEE_TBL E, EMPLOYEE_PAY_TBL EPWHERE E.EMPLOYEE_ID = EP.EMPLOYEE_ID AND E.NAME LIKE '%MITH';d-) SELECT ENAME, COUNT(*)FROM EMPWHERE ENAME = '&NAME'ORDER BY ENAME;e-) SELECT DEPT_ID, COUNT(*)FROM EMPGROUP BY DEPT_IDHAVING ENAME='ALIYE';f-) SELECT F_NAME, L_NAMEWHERE F_NAME LIKE '%A'FROM EMP, DEPT;g-) SELECT NAME, SALARYFROM DEPT, EMPWHERE DEPT.ID = EMP.ID AND SUM(SALARY);
Question 9 Convert the following QUERIES to Stored Procedures with IN parameters In MySQL select customerNamefrom customerswhere customerNumber in(select customerNumberfrom orders where orderNumberin(select orderNumber fromorderdetails) ); Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
Hello I am receiving this error whenever I try to import it into MySQL using this code SELECT store_id AS Store, COUNT(*) AS Num_CustomersFROM sakila.customerGROUP BY store_idORDER BY store_id DESC, COUNT(*) DESC;SELECT film.title AS Title, rental.rental_date AS Rental_Date, rental.return_date AS Return_DateFROM sakila.customerJOIN sakila.rental ON customer.customer_id = rental.customer_idJOIN sakila.inventory ON rental.inventory_id = inventory.inventory_idJOIN sakila.film ON inventory.film_id = film.film_idWHERE customer.first_name = 'JO' AND customer.last_name = 'FOWLER'ORDER BY rental.rental_date ASC;REPLACE VIEW top_rental_films ASCREATE OR SELECT film.title AS FilmTitle, COUNT(rental.rental_id) AS Num_Rentals, AVG(payment.amount) AS Avg_AmtFROM sakila.filmJOIN sakila.inventory ON film.film_id = inventory.film_idJOIN sakila.rental ON inventory.inventory_id = rental.inventory_idJOIN sakila.payment ON rental.rental_id = payment.rental_idGROUP BY film.film_idORDER BY…
Below is the answer I got but it is incorrect select PROJ_NUM, ROUND(SUM(ASSIGN_HOURS),2) as 'TOTAL_HOURS', ROUND(SUM(ASSIGN_CHARGE),2) as 'TOTAL_CHARGE' from ASSIGNMENT -- from ASSIGNMENT table group by PROJ_NUM; -- group by to aggregate per PROJ_NUM
Using MySQL, populate the CUST_LNAME, CUST_FNAME, and CUST_BALANCE fields with the following customers: CUST_LNAME CUST_FNAME CUST_BALANCE Smith Jeanne 1050.11 Ortega Juan 840.92
Question 16 kk Draw the process of top-down parsing for id + id * id with E → TE’ E’ → +TE’ / ∈ T → FT’ T’ → xFT’ / ∈ Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
Im still receiveing an error. ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GET_CREDIT_LIMIT with CUST_ID ('125')' at line 1.ERROR 1318 (42000) at line 1: Incorrect number of arguments for PROCEDURE KimTay.GET_CREDIT_LIMIT; expected 3, got 1 tried to use this GET_CREDIT_LIMIT with CUST_ID ('125'); I also tried to figure it out using these three arguments and use this below - call the procedure GET_CREDIT_LIMIT with CUST_ID 125 CALL GET_CREDIT_LIMIT(125, @I_CUSTOMER_NAME, @CREDIT_LIMIT); SELECT @I_CUSTOMER_NAME, @CREDIT_LIMIT; Still not right
Hi, This is what I have, but I am stuck with what to write and not sure if my function is even correct, to begin with. Can someone show me a walk-through solution? MUST USE postgreSQL CREATE TABLE instructor_course_nums (ID VARCHAR(25), name VARCHAR(25), tot_courses VARCHAR(25)); CREATE OR REPLACE PROCEDURE calculate_instr_course(ID VARCHAR(25), name VARCHAR(25), tot_courses VARCHAR(25))LANGUAGE plpgsqlAS$$BEGIN END;$$;
Which of these statements regarding the VLOOKUP function is true? Question 18 options: A) The VLOOKUP function can be set up to find either exact or approximate matches for a value that is being looked up. B) Numerical values in the first column of the table must always be in decending order. C) When the VLOOKUP function is used to find an exact match to a text value the fourth argument is TRUE. D) With using VLOOKUP, the comparison table is read horizontally.