Write SQL queries for this database

Create the following queries on the COMPANY database and show their results.

Here is my database https://www.mediafire.com/file/7g9p5hb1h3mkmm2/COMPANY_1.txt

1.Retrieve the names of all employees in department 4 who work less than 20 hours per week on the 'Computerization' project.

2.Retrieve the employee name, salary, and supervisor name for each employee who works in the Research department.

3.List the department name and the number of employees in that department who are making more than $32,000.

4.For each department whose average employee salary is more than $32,000, retrieve the department name and the number of employees in that department.