hello can you assist me with this problem

Write the SQL queries to answer the following questions based on the ConstructCo database. Save your queries in a text or a Word file and submit here. 1. Write the SQL code required to list the employee number, first and last name, middle initial, and the hire date. Sort your selection by the hire date, to display the newly hired employees first. 2. Modify the previous query and list the employee first, last name and middle initial as one column with the title EMP_NAME. Make sure the names are listed in the following format: First name, space, initial, space, last name (e.g. John T Doe). Hint: use + to concatenate the fields and use ' 'to add a space to your text. E. g. EMP_FNAME + '' + EMP_LNAME. 3. Write the SQL code that will list only the distinct project numbers in the ASSIGNMENT table, sorted by project number. 4. Using the EMPLOYEE and PROJECT tables, write the SQL code that will join the tables on their common attribute and display the names and numbers of the projects and the employees who lead these projects. 5. Modify the query in 5 to display all employees and not just the ones who lead projects. 6. Using the EMPLOYEE, JOB, and PROJECT tables in the ConstructCo database, write the SQL code that will join the EMPLOYEE and PROJECT tables using EMP_NUM as the common attribute. Display the attributes shown in the results presented in the attached screen shot, sorted by project value. 7. Using JOB and EMPLOYEE tables, list the jobs and the names of employees who currently have these job categories. List all jobs, even the ones that do not have any matches in the EMPLOYEE table. 8. Write a query to list the names of all employees, the names of the projects to which they are assigned, and the name of employees who lead these projects