Look at the SQL Database provided and write the code needed for each answer. The first answer is provided.

1) What is Bezalel Simmels birthday?

SELECT birth_date FROM employees WHERE first_name = 'Bezalel' AND last_name = 'Simmel'

2) What departments are in the company?

3) What department does Guoxiang Nooteboom work in?

4) What is Lillian Haddadis current title?

5) What is Mary Sluiss current salary?

6) What is the first and last name of the current manager of the Customer Service Department?

salaries dept_emp PK,FK1 emp_no INT *PK,FK PK PK,FK2 dept_no VARCHAR(4) from_date DATE to_date DATE emp_no INT from_date DATE to_date DATE salary INT HPK e PK departments dept_no VARCHAR(4) dept_name VARCHAR(40) employees emp_no INT birth_date DATE first_name VARCHAR(14) last_name VARCHAR(16) gender VARCHAR(1) (M,F) hire_date DATE titles - dept_manager PK,FK1 emp_no INT PK,FK2 dept_no VARCHAR(4) PK,FK emp_no INT title VARCHAR(50) from_date DATE to_date DATE PK from_date DATE to_date DATE