1. Write the SQL query to retrieve the following information of all employees: 

a. Employee number

b. Employeelastname

c. Date of hire

d. Jobcode.

The company wants to send a check to their employees as a gift. The amount of the check will be calculated based on the employee's experience. So, for each year of working in the company, they will be paid $30. Write a query to show the employees number, last name, job description (not the job code), years of their experience, and the amount of money that they will be paid.

Write a query to retrieve first and last name of the employees that are manager in any project (EMP_NUM column in project table shows the employee number of the project managers for each project)

Write a query to retrieve Last name of all the employees and the projects that they are assigned to.