2. DATABASE PLEASE TYPE ANSWER

Write the DQL for the following:

All Employees, their titles, salaries, and the department they work for making over fifty thousand dollars.

All department managers information, his or her department information, and start date.

Total salary paid to all employees in each department.

Average number of managers per department.

Total number of department managers.

salaries emp-no INT (10) salary INT(11 from date DATE to date DATE Indexes titles emp no INT(10 title VARCHAR(50) from date DATE to date DATE Indexes employees emp-no INT(10) LH birth date DATE first name VARCHAR(14) last name VARCHAR(16) gender ENUM (M', F) hire date DATE Indexes dept manager dept no CHAR(40 emp no INT(10) from date DATE to date DATE Indexes dept emp emp no INT(10) dept no CHAR(4) from date DATE to date DATE Indexes dept no CHAR(4) dept name VARCHAR(40) Indexes