4. Write a SELECT statement to list the employees name whose address start with 234 Duarte.

5. Write a SELECT statement to list the cities which zip codes include 10 in it.

6. Write a SELECT statement to list all employees who lives either in zip code 91006, 91023, or 11420.

7. Write a SELECT statement to list the information of employees whose id is less than or equal 150.

8. Write a SELECT statement to list employee name and address where name ends with D.

9. Write a query and add one record into emp_id, emp_name, dept_id columns in table.

10. Write a query and add one record in all columns in Employee table.

11. Write a query and add a new column to department table, and name it dept_address.

12. Write a query and update the salary for employee by id equal 105 to $5000.

13. Write a query to see all records of department table. 14. Write a query to find out the number of records in employee table.