Write SQL statements

Consider the following relational schema * titles employees emp no NUMERIC(6.0) title from date DATE to date DATE emp-no NUMERIC(6,0) birth date DATE first name CHARACTER VARYING(14) last name CHARACTER VARYING(16) gender CHARACTER(1) hire date DATE CHARACTER VARYING(50) salaries emp no NUMERIC60) salary NUMERIC(6,0) from date DATE to date DATE dept manager dept no CHARACTER(4) / emp-no NUMERIC(6,0) from date DATE to date DATE departments dept no CHARACTER(4) dept name CHARACTER VARYING(40) dept emp emp no NUMERIC6.0) deptno CHARACTER(4) from date DATE to date DATE