SQL Queries Final

[Charade]

Hello, my finals start tomorrow and my first exam is from the Database Management System course. I would be very glad if you could answer the following questions. I have answered the first 11 questions, but I need to study for my other exam, so I would greatly appreciate your help with these. 12. SQL statement that gives the number of people in the company who receive the highest salary. 13. SQL statement listing the names and surnames of the personnel receiving the lowest salary in the departments. 14. SQL statement giving the number of personnel by department. 15. SQL statement listing the names of departments with at least 3 working personnel. 16. SQL statement to delete the personnel with the role "Cleaner". 17. SQL statement updating the salary of the personnel with the lowest salary in each department by 5%. 18. Write an SQL statement to order male personnel from youngest to oldest. 19. Write an SQL statement that gives the number of female personnel in the company. 20. Update the birthplace of the personnel with the surname 'Uysal' to 'Erzurum'. 21. Write an SQL statement to give the number of personnel by job title. 22. Write an SQL statement to list the personnel who are not clerks, chiefs, or marketers. 23. An annual total income calculation is desired for personnel. Accordingly, the annual salary will be calculated and the annual total income will be calculated by adding the commission amount. Only some personnel receive commission. The information of personnel not receiving commission is saved as NULL. What should the SQL statement be? 24. Write an SQL statement to calculate the total salary and average salary for each department in the PERSONNEL table. 25. Write an SQL statement listing the department number and average salary of the department if the department salary average is greater than 2000. 26. Write an SQL statement listing personnel whose names start with "A" or whose job starts with "M" in the PERSONNEL table. 27. Write an SQL statement listing the names of personnel who earn more than the salary of personnel number "140". 28. Write an SQL statement listing the departments where the lowest salary is greater than the lowest salary of department number "30". 29. Write an SQL statement listing personnel who earn less than the highest earning CLERK. 30. Write an SQL statement listing personnel whose salary is greater than the average salary of all departments.