Write a stored procedure in MySQL that will change the price of an item with a given number. How would you use this stored procedure to change the price of item AH74 to $26.95?

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;$$;

Based on the table below, what values would appear in range C4:E6 when the contents of C3:E3 are auto-filled downward towards row 6? 123 2 3 5 56 6 A Blank # 1 Blank # 2 Blank # 3 Blank # 4 Blank # 5 Blank # 6 Blank #7 Blank # 8 Blank #9 Initital Values 2 4 6 8 C C3=$83*3 6 Blank #1 Blank #2 Blank #3 D D3-8$3*3 6 Blank #4 Blank #5 Blank #6 E E3-$B$3*3 6 Blank #7 Blank #8 Blank #9 A/ A A A A N

R7

In the data set below, what is the mean and the standard deviation? Round answers to the hundredth place. A = {5, 6, 7, 7, 8, 10, 12}

Write a stored procedure named displayCountryMessage(). The displayCountryMessage () should receive one input argument for the country name and then based on that input argument, display a short message and the name of the country. Otherwise, if the country does not exist in the country table, then the procedure should display an appropriate message. For example, if I call the displayCountryMessage() procedure and pass it “France”, then it will display the message “France exists in the Country table”. If I call the displayCountryMessage()procedure and pas it “AAAAA”, then it will display the message “AAAAA does NOT exist in the Country table”.

Write a servlet to display a table that contains factorials for thenumbers from 0 to 10, as shown in Figure .

write the code for the following triggers in MySQL following the style shown in the text. A: When adding a customer, add the customer balance multiplied by the sales rep's commission rate to the commission for the corresponding sales rep. B: When updating a customer, add the difference between the new balance and the old balance multiplied by the sales rep's commission rate to the commission for the corresponding sales rep. C: When deleting a customer, subtract the balance multiplied by the sales rep's commission rate from the commission for the corresponding sales rep.   CREATE TABLE REP(REP_NUM CHAR(2) PRIMARY KEY,LAST_NAME CHAR(15),FIRST_NAME CHAR(15),STREET CHAR(15),CITY CHAR(15),STATE CHAR(2),POSTAL_CODE CHAR(5),COMMISSION DECIMAL(7,2),RATE DECIMAL(3,2) );CREATE TABLE CUSTOMER(CUSTOMER_NUM CHAR(3) PRIMARY KEY,CUSTOMER_NAME CHAR(35) NOT NULL,STREET CHAR(20),CITY CHAR(15),STATE CHAR(2),POSTAL_CODE CHAR(5),BALANCE DECIMAL(8,2),CREDIT_LIMIT DECIMAL(8,2),REP_NUM CHAR(2) );INSERT INTO…

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);

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?