1. Write SQL Statements to insert at least three rows of data into each of these above tables. Assume that any surrogate key value will be supplied by the DBMS as described above.
2. Write a SQL Statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master and LastName that begins with the letter J. (Change LastName to display 'Last Name' and FirstName to display 'First Name' and CellPhone to display 'Cell').
3. Write a SQL Statement to list the LastName and FirstName of employees who have worked on a property in Seattle. Use a SUBQUERY only.
4. Write a SQL Statement to list the LastName and FirstName of employees who have worked on a property owned by a Corporation. Use a JOIN only.
5. Write a SQL Statement to show the name and sum of hours worked for each employee.
6. Write a SQL Statement to modify all EMPLOYEE rows with ExperienceLevel of Master to SuperMaster.