Use Figure p7.1 for the following questions

1. Write the SQL code required to

Output

Employee number

Last name

first name

middle intial

Requirement

Only return the above for users whose Last Name starts with SMITH

Sort the output table by Employee Number

Note

- Rows for both Smith and Smithfield should be included. So any name who begins with SMITH

2. Use EMPLOYEE JOB and PROJECT table in (Figure p7.1).

a. Write the SQL code that will join EMPLOYEE and PROJECT table using EMP_NUM as the common attribute and result in the table shown in the image "p7.2 Query Results")

b. Witrite the SQL code that will produce the same information as a. but sorted by employee's last name

FIGURE P7.1 THE CH07_CONSTRUCTCO DATABASE Relational diagram Table name: EMPLOYEE Database name: Ch07_ConstructCo Table name: JOB Tahla name. ASCICNMENT Table name: PROJECT FIGURE P7.2 THE QUERY RESULTS FOR PROBLEM 2