Write a memo in about 50 words.
You are the Personnel Manager of a company, and have been approached by your IT Department to recruit three new members of staff. Write a memo to Miss Kate Bush, the Manager of the IT Department,
·informing her you have received over 100 applications and have selected 10 candidates for interview,
·telling her you will write to the candidates inviting them for interview, and
·asking her to tell you the time and the place of the interview.

— Hello, this is John speaking. Could I speak to Mike?

—                      

— Hi, I'm Melinda Smith, the new secretary. Nice to meet you here.

— Hi, I'm Mike Brown from the Training Center.                 

Examine the data of the EMPLOYEES table.
EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)

Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000?（）

You need to perform these tasks:
1. Create and assign a MANAGER role to Blake and Clark
2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark
Which set of SQL statements achieves the desired results? （）