Question 1 and 2

1. Write the SQL code required to list the employee number, last name, first name, and middle initial of all employees whose last names start with Smith. In other words, the rows for both Smith and Smithfield should be included in the listing. Sort the resulis by employee number. Assume case sensitivity. 2. Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_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 Figure P7.2, sorted by project value. Figure P7.2 The Query Results for Problem 2 Details A table has nine columns and four rows with the following column headers: PROJ NAME, PROJ VALUE, PROJ BALANCE, EMP NAME, EMP F NAME, EMP INITIAL, JOB CODE, JOB DESCRIPTION, JOB C H G HOUR. For example, the first row reads: Rolling tide, 805,000 point 00,500,345 point 20, Senior, David, H,30 1, Systems Analyst, and 96 point 75. 1. Write the SQL code required to list the employee number, last name, first name, and middle initial of all employees whose last names start with Smith. In other words, the rows for both Smith and Smithfield should be included in the listing. Sort the resulis by employee number. Assume case sensitivity. 2. Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_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 Figure P7.2, sorted by project value. Figure P7.2 The Query Results for Problem 2 Details A table has nine columns and four rows with the following column headers: PROJ NAME, PROJ VALUE, PROJ BALANCE, EMP NAME, EMP F NAME, EMP INITIAL, JOB CODE, JOB DESCRIPTION, JOB C H G HOUR. For example, the first row reads: Rolling tide, 805,000 point 00,500,345 point 20, Senior, David, H,30 1, Systems Analyst, and 96 point 75