Open SQL developer and create a new connection to Oracle server

Express the following queries in SQL:

a) List first name, last name and department ID of all employees ordered according to hire date in descending order. [1.5 mark]

b) Display the details (Employee ID, First Name, Salary, department ID) of employees working in department number 90. [1.5 marks]

c) List First name and Last name of employee whose last name start with the letters 'MA'. [1.5 marks]

d) List the details (Employee ID, First Name, Salary, Commission) of employees whose salary is greater than 11000 and they should have a commission. The output should be like in the following picture: [1.5 marks]

e) Display the sum of salaries of employees from each department ordered in ascending order. [1.5 marks]

f) Display first name, last name and job title of all employees. [1.5 marks]

g) List the number of employees managed by every manager. The output should look like in the following picture: [1.5 marks]