use EMP and DEPT tables, in the Live SQL, to perform the following operations. 1- List the Departments's Names that have no employees 2- List the name of the employees' Names, dept's Names, and the SAL in JD rounded to 2 digits (one dollar = 0.7 JD). EMP and DEPT tables: https://livesql.oracle.com/apex/livesql/file/content_O5AEB2HE08PYEPTGCFLZU9YCV.html

Q: Create a new table, EMP_PROMOTION to store the employees information. You must use a subquery to…

A: Objective: A table "EMP_PROMOTION" would be created using sub-query from an existing relation…

Q: 1. Write an SQL query to list the name of all Departments that have 2 more more words in the…

A: Introduction: In this question, we are given schema and asked to write two queries.

Q: Write SQL code that returns the EMP_NUM and Number of ratings he/she earned (based on EARNEDRATING…

A: As per the given question, we need to write a SQL query that returns the EMP_NUM and Number of…

Q: Using the Online SQL Editor, answer the following questions with screenshots. Link:…

A: In this task, we were given a set of questions to answer using an online SQL editor. The objective…

Q: 8) Display the firstname, lastname of the employees and the customerID that the employee served such…

A: Please refer to the following step for the complete solution to the problem above.

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.