Please write a stored function named `fHW_10_xxxx()` which will return the total payment amount for a given student ID and a year. Please refer to the Students, Courses, Students_Courses tables. Assume each credit is $100.### Examples and Expected Outputs#### Example 10.1```sqlselect fHW_10_demo(2000, 1001) as output;```**The above SQL statement will return:**```+---------------------------------------------------+| output |+---------------------------------------------------+| No result found for student ID: 1001 at year: 2000|+---------------------------------------------------+```#### Example 10.2```sqlselect fHW_10_demo(2016, 1001) as output;```**The above SQL statement will return:**```+--------+| output |+--------+| 400 |+--------+```#### Example 10.3```sqlselect fHW_10_demo("", 1002) as output;```**The above SQL statement will return:**```+------------------------+| output |+------------------------+| Please input valid year.|+------------------------+```#### Example 10.4```sqlselect fHW_10_demo(2017, null) as output;```**The above SQL statement will return:**```+---------------------------------+| output |+---------------------------------+| Please input valid student id. |+---------------------------------+```These examples illustrate how the function should manage different scenarios, including invalid inputs and non-existent data.

Solution: Considering the name of the schema(database) is student_db. MySQL query for creating schema and inserting value: DROP DATABASE IF EXISTS STUDENT_DB; CREATE DATABASE STUDENT_DB; USE STUDENT_DB; CREATE TABLE STUDENTS ( SID INT PRIMARY KEY, FIRST_NAME VARCHAR(20) NOT NULL, LAST_NAME VARCHAR(20), BIRTHDAY DATE NOT NULL, MAJOR VARCHAR(15) NOT NULL, ZIPCODE CHAR(5) ); CREATE TABLE COURSES( CID CHAR(7) PRIMARY KEY, NAME VARCHAR(30) NOT NULL, CREDITS INT NOT NULL ); CREATE TABLE STUDENTS_COURSES( SID INT NOT NULL, CID CHAR(7) NOT NULL, YEAR VARCHAR(4) NOT NULL, SEMESTER VARCHAR(10) NOT NULL, GRADE VARCHAR(2) NOT NULL, FOREIGN KEY(SID) REFERENCES STUDENTS(SID), FOREIGN KEY(CID) REFERENCES COURSES(CID) ); INSERT INTO STUDENTS VALUES (1001, 'AUSTIN', 'HUANG', '1990-01-01', 'CS', '07123'), (1002, 'MARY', 'SMITH', '1976-06-08', 'IT', '08348'), (1003, 'CLAUDIA', 'LEE', '1987-03-21', 'MATH', '91384'), (1004, 'ANDREW', 'LIN', '1947-08-25', 'BIOLOGY', '07101'), (1005, 'HELEN', 'WU', '1997-01-25', 'CS', '07083'), (1007, 'SARAH', 'LEE', '1995-09-15', 'IT', '04101'); INSERT INTO `student_db`.`COURSES` (`CID`, `NAME`, `CREDITS`) VALUES ('CPS1231', 'JAVA1', '4'); INSERT INTO `student_db`.`COURSES` (`CID`, `NAME`, `CREDITS`) VALUES ('CPS2231', 'JAVA2', '4'); INSERT INTO `student_db`.`COURSES` (`CID`, `NAME`, `CREDITS`) VALUES ('CPS2232', 'DATA STRUCTURE', '4'); INSERT INTO `student_db`.`COURSES` (`CID`, `NAME`, `CREDITS`) VALUES ('CPS3500', 'WEB PROGRAMMING', '3'); INSERT INTO `student_db`.`COURSES` (`CID`, `NAME`, `CREDITS`) VALUES ('CPS3740', 'DATABASE INTRODUCTION', '3'); INSERT INTO `student_db`.`COURSES` (`CID`, `NAME`, `CREDITS`) VALUES ('CPS5920', 'DATABASE SYSTEMS', '3'); INSERT INTO `student_db`.`COURSES` (`CID`, `NAME`, `CREDITS`) VALUES ('CPS5921', 'DATA MINING', '3'); INSERT INTO STUDENTS_COURSES VALUES (1001, 'CPS2231', '2013', 'FALL', 'A-'), (1003, 'CPS2231', '2015', 'SPRING', 'A'), (1004, 'CPS2231', '2014', 'SPRING', 'A-'), (1001, 'CPS2232', '2016', 'FALL', 'C+'), (1004, 'CPS2232', '2014', 'SPRING', 'B+'), (1005, 'CPS2231', '2016', 'SPRING', 'A'), (1007, 'CPS2231', '2015', 'SPRING', 'B'), (1003, 'CPS5920', '2016', 'FALL', 'C'), (1007, 'CPS3740', '2014', 'FALL', 'A'), (1003, 'CPS5921', '2016', 'SPRING', 'B'), (1001, 'CPS3500', '2017', 'SPRING', 'C+'), (1003, 'CPS2231', '2014', 'FALL', 'F'), (1004, 'CPS2232', '2014', 'FALL', 'C'), (1004, 'CPS2231', '2013', 'FALL', 'C');Procedure Code Screenshot: Procedure Code to Copy: USE `student_db`; DROP procedure IF EXISTS `fHW_10_demo`; DELIMITER USE`studentdb` USE `student_db` CREATE PROCEDURE `fHW_10_demo`(IN C_YEAR VARCHAR(4), IN S_SID INT, OUT fHW_10_demo VARCHAR(50)) BEGIN DECLARE sub Varchar(50); SELECT (CREDITS * 100) INTO sub FROM COURSES C, STUDENTS_COURSES SC WHERE SC.SID=S_SID AND SC.YEAR = C_YEAR AND C.CID = SC.CID; IF C_YEAR IS NULL OR C_YEAR = '' THEN SET fHW_10_demo = 'Please input valid year.'; ELSEIF S_SID IS NULL THEN SET fHW_10_demo = 'Please input valid student id.'; ELSE IF SUB IS NULL THEN SET fHW_10_demo = CONCAT('No result found for student ID: ', S_SID, ' AT YEAR: ', C_YEAR); ELSE SET fHW_10_demo = sub; END IF; END IF; END$$ DELIMITER ;Output Sample: :