From the Company Schema, provide a select statement that returns the employee ssn, last name, project names and hours-worked for the employees with the last name Smith. Hint: This will require a nested join between three tables.

Company Schema (Crows Foot ER Diagram) employee ssn CHAR(9) superssn CHAR(9) (FK) dno BIGINT (FK) fname VARCHAR(15) minit VARCHAR(1) Iname VARCHAR(15) bdate DATE address VARCHAR(50) sex CHAR(1) salary DECIMAL (10,2) dept_locations dnumber BIGINT (FK) dlocation VARCHAR(15) essn CHAR(9) (FK) dependent_name VARCHAR 15) sex CHAR(1) bdate DATE relationship VARCHAR(8) department dnumber BIGINT mgrssn CHAR(9) (FK) dname VARCHAR(25) mgrstartdate DATE works on essn CHAR(9) (FK) pno BIGINT (FK) hours DECIMAL(4.1) project pnumber BIGINT dnum BIGINT (FK) pname VARCHAR(25) plocation VARCHAR(15) CS 4347 Introduction to Database Systems