I need help solving a lab in mysql 

"Database 1" Lab Participation Due Date: Thursday, 20 April 2023 The Sample Tables Note: - Primary Key of EMP Table is EMPNO and Foreign Key is DEPTNO that References DEPT (DEPTNO) - Primary Key of DEPT table is DEPTNO Write SQL statements to 1. Create above table 2. Populate tables with given data 3. Display the contents of the DEPT, EMP 4. Display the name and SAL of all the employees together with another column that shows their annual salary (SAL*12). 5. Display the job title of all the employees working in Department number 30 (no duplicate rows). 6. Display number of employees working in each department. 7. Delete employees working in department 20 . 8. Change the department no. to 30 for all employees working as 'Clerk'. 9. Remove EMP table. 10. Display Employee names along with their department names