Show output under problems

E3 Mysql Program Design Experimental Objective You are required to utilize the fol operations expertly under Mysql platform. Experimental Requirement lowing SOL 1 Basic Hardware ConfigurationIntel Pentiumlllor above, Greater than 512MB memory 2, Software Requirement: Mysql 3 Hours: 2h 4, Experiment Report after Experiment. Problem 1. A block of code is required to get the number of employees according to the input variabe deptcode. use example; set @deptcode 1; set @personnum-0; select count () into @personnum from emp where deptno @deptcode; select @personnum; Problem 2. Write a code block contains part of the definition, execution and exception handling: according to the empno of employee, output the employees name, salary and department name; if the inputted employee empno does not exist, then output error message Problem 3. Write a block of code, according to the rameter of the employee number (empno) annual income and print it. Problem 4. Write a code block containing part of the definition, execution and exception handling, which realizing the following function: according to the department number output the names, salaries of all employees in this department.If the department does not exist,outputting error message