I am having some issues in MySQL Workbench. Please take a look at the images and tell me what I am doing wrong and answer the questions: Write MySQL, procedures to retrieve and output the item ID, description, location, and price of every item in the category stored in I_CATEGORY.Write a stored procedure in MySQL, that changes the price of an item with a given item ID. How would you use this stored procedure to change the price of item AD72 to $84.99?Please let me know if any other info is needed to get this to work correctly. vA ViewMYSQL WorkbenchO XLocal instance MYSQL80 xFileEditViewQueryDatabaseServerToolsScriptingHelpNavigator :SQL File 14*SQL File 18SQL File 19*SOL File 20SQL File 13"SQLAdditions• | 1 , | Jump toSCHEMASLimit to 1000 rowsa Filter objectsAutomatic context help isdisabled. Use the toolbar tv9 kimtay2 •0 CREATE PROCEDURE ITEM CATGRY_PROC (Tables3 0I_ITEM_ID QUT ITEM.ITEM_ID%TYPE,manually get help for thecurrent caret position or totoggle automatic help.customerI_DESCRIPTION OUT ITEM.DESCRIPTIONXTYPE,I LOCATION OUT ITEM. LOCATIONXTYPE,4O ColumnsA IndexesA Foreign KeysG Triggersinvoice_lineI PRICE OUT ITEM.PRICEXТҮРЕ,I_CATEGORY IN ITEM.CATEGORYXTYPE)invoices8ASitemva ColumnsA BEGIN10SELECT ITEM_ID, DESCRIPTION, LOCATION, PRICE,ПЕМ_IDDESCRIPTION11INTOON_HAND12I_ITEM_ID, I_DESCRIPTION, I_LOCATION, I_PRICE,CATEGORY13FROMLOCATIONPRICE14ITEM9 IndexesA Foreign KeysA Triggers15WHERECATEGORY = I CATEGORY;DBMS OUTPUT.PUT_LINE (I_ITEM_ID);16noncat17 0I repI sales_rep18 3REMSQUTPUT. PUT_LINE(I_DESCRIPTION);DEMS OUTPUT. PUT_LINE(I_LOCATION);DEMS OUTPUT. PUT_LINE(I_PRICE);19 020 3invoice_totalDBMS OUTPUT. PUT LINE;item_invoiceE major_customerv A Stored ProceduresA GET_CREDIT_LIMITE Functions9 sakilaE sysE world21 022 0END;2324Administration SchemasInformationContext Help SnippetsNo object selectedOutputA Action OutputDurationTimeActionMessage/ Fetch1 12:55:50 CREATE PROCEDURE ITEM_CATGRY_PROC (I_ITE..Error Code: 1064, You have an error in your SQL syntax;0.000 secObject InfoSession6. Write MYSQL, procedures to retrieve and output the item ID, description, location, andprice of every item in the category stored in I_CATEGORY.Complete this question7. Write a stored procedure in MYSQL, that changes the price of an item with a given itemID. How would you use this stored procedure to change the price of item AD72 to$84.99?Hint:DEL. //CREATE PROCEDURE ADD INVOICE (IN I INVOICE NUM CHAR (5),IN I INVOICE DATE DATE,IN I CUST ID CHAR (5))Complete this question A MYSQL WorkbenchLocal instance MYSQL80 xFileEditViewQueryDatabaseServerToolsScripting HelpNavigator :SQL File 14SQL File 18SQL File 19*SQL File 20* x SQL File 13*SQLAdditions wwwSCHEMAS• | 12 1, | Jump toLimit to 1000 rowsa Filter objects1Automatic context help isdisabled. Use the toolbar tv9 kimtay2• 0 CREATE PROCEDURE ITEM CATGRY PROC (TablesI_ITEM_ID QUT ITEM.ITEM_ID%TYPE,manually get help for theVE customerO ColumnsE IndexesA Foreign KeysA TriggersA invoice line4I DESCRIPTI "OUT" is not valid at this position, expecting BIGINT, BINARY, BIT, BLOB, BOOLEAN, BOOL, ...I LOCATION OUT ITEM. LOCATION%TYPE,toggle automatic help.I_PRICE OUT ITEM.PRICEXTYPE,7I CATEGORY IN ITEM.CATEGORY%TYPE)invoices8ASitemO BEGINVO Columns10SELECT ITEM ID, DESCRIPTION, LOCATION, PRICE,+ ПЕМ ID• DESCRIPTION• ON_HAND• CATEGORY• LOCATION• PRICEA IndexesA Foreign KeysA Triggers11INTO12I_ITEM_ID, I_DESCRIPTION, I_LOCATION, I_PRICE,13FROM14ITEM15WHERE16CATEGORY = I CATEGORY;DEMS QUTPUT. PUT_LINE (I_ITEM_ID);DBMS OUTPUT. PUT_LINE(I_DESCRIPTION);DEMS OUTPUT.PUT LINE(I LOCATION);попcat17 0rep18 0>I sales_rep19 0DEMS OUTPUT. PUT_LINE(I_PRICE);DEMS QUTPUT.PUT_LINE;20 0E invoice_totalO item_invoice21 0>E major_customera Stored ProceduresA GET CREDIT_LIMITE Functions22 0END;2324>3 sakila>E sys>E worldAdministrationSchemasInformationContext Help SnippetsNo object selectedOutput *A Action OutputDuration/ FetchTimeActionMessage1 12:55:50 CREATE PROCEDURE ITEM_CATGRY_PROC (L_ITE.Error Code: 1064. You have an error in your SQL syntax; . 0.000 secObject Info Session6. Write MYSQL, procedures to retrieve and output the item ID, description, location, andprice of every item in the category stored in I_CATEGORY.Complete this question7. Write a stored procedure in MySQL, that changes the price of an item with a given itemID. How would you use this stored procedure to change the price of item AD72 to$84.99?Hint:DEL. //CREATE PROCEDURE ADD INVOICE (IN I INVOICE NUM CHAR (5),IN I INVOICE DATE DATE,IN I CUST ID CHAR (5))Complete this questionAA AAAA

Program: Query: CREATE OR REPLACE PROCEDURE ITEM_CATGRY_PROC ( I_ITEM_NUM OUT ITEM.ITEM_NUM%TYPE, I_DESCRIPTION OUT ITEM.DESCRIPTION%TYPE, I_STOREHOUSE OUT ITEM.STOREHOUSE%TYPE, I_PRICE OUT ITEM.PRICE%TYPE, I_CATEGORY IN ITEM.CATEGORY%TYPE) AS BEGIN SELECT ITEM_NUM, DESCRIPTION, STOREHOUSE, PRICE INTO I_ITEM_NUM, I_DESCRIPTION, I_STOREHOUSE, I_PRICE FROM ITEM WHERE CATEGORY = I_CATEGORY; DBMS_OUTPUT.PUT_LINE(I_ITEM_NUM); DBMS_OUTPUT.PUT_LINE(I_DESCRIPTION); DBMS_OUTPUT.PUT_LINE(I_STOREHOUSE); DBMS_OUTPUT.PUT_LINE(I_PRICE); DBMS_OUTPUT.PUT_LINE; END; output: Triggering procedure to retrieve records on basis of category provided as input, BEGIN ITEM_CATGRY_PROC(‘TOY’); END; / CD33 Wood Block Set (48 pieces) 1 $89.49 DE51 Classic Railway Set 3 $107.95