Please write SQL queries and SQL*Plus

Please write SQL queries and SQL*Plus

Please write SQL queries as instructed below.
please ensure that it executes successfully in SQL*PLUS.
You do not have to paste the results (just paste the query).

(A) Write a Query to display the name, department_id of the employee that earns the highest salary in the Employees table.

(B) Write a query that displays the name and ID of all departments with the names of the employees in that department.
Display a department even if there is no employee in that department.

Please write SQL queries as instructed below.
please ensure that it executes successfully in SQL*PLUS.
You do not have to paste the results (just paste the query).

(A) Write a Query to display the name, department_id of the employee that earns the highest salary in the Employees table.

(B) Write a query that displays the name and ID of all departments with the names of the employees in that department.
Display a department even if there is no employee in that department.

Is this the question you were looking for? If so, place your order here to get started!