use EMP and DEPT tables, in the Live SQL, to perform the following operations. List the Departments's Names that have no employees solution: select de.DNAME Department_Name, count(em.EMPNO) No_Of_Employees from SCOTT."EMP" em,SCOTT."DEPT" de where em.DEPTNO = de.DEPTNO group by de.DNAME;

use EMP and DEPT tables, in the Live SQL, to perform the following operations. List the Departments's Names that have no employees solution: select de.DNAME Department_Name, count(em.EMPNO) No_Of_Employees from SCOTT."EMP" em,SCOTT."DEPT" de where em.DEPTNO = de.DEPTNO group by de.DNAME;

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter6: Updating Data

Section: Chapter Questions

Problem 12SCG

See similar textbooks

Related questions

Q: Write a query to fetch employee names and salary records. Display the employee details even if the…

A: Given: Write a query to fetch employee names and salary records. Display the employee details even…

Q: in pl/sql ,use Cursor to get all the records from table job_history for employee_id 121

A: pl/sql code for the above question is solved in step 2:- assume table job_history has columns…

Q: select em.ENAME,em.SAL from SCOTT."EMP" em where em.ENAME like '%jon%'; but i need it using soundex…

A: SQL is a structured query language, it's is used to extract and manipulate the data from the table.…

Q: IN SQL, POSTGRESQL. For customer, product and state, show the average sales before and after each…

A: The solution for the above given question is given below:

Q: Using the sample "Solmaris Condo" "database" (just a bunch of tables with a theme) I had you create…

A: SAMPLE DATABASE TABLE: OFFICE OFFICE_NUM OFFICE_NAME ADDRESS AREA CITY STATE ZIP_CODE 1…

Q: Consider the following tables. Name - dbo.Patient Columns - PatientId, First name, Last name,…

A: I have given an answer in step 2.

Q: based on the information below create a oracle SQL table and insert some values into each table.…

A: The CREATE TABLE statement is used to create table in oracle SQL. Synatx for creating table: create…

Q: Submit just the SQL to: Return all of the contact names, and contact titles for all customers whose…

A: The SQL query is given below.

Q: using Oracle write and run a PL/SQL block that populates the table Malasiya_Suppliers --- from the…

A: Given data, write and run a PL/SQL block that populates the table Malasiya_Suppliers from the…

Q: Use Default tables and write Sql queries for following Question. Attach the Screenshot of output.…

A: Note:- As per our guidelines, for multiple questions we are supposed to answer only one question.…

Q: How can I remove the duplicates in SQL? Here is the code. SELECT [EmployeeID] ,[RoleID]…

A: Note: The content of the database is not given so only the required answer is given(without output)…

Q: Consider Following Tables. Student ( regNo, sName, sCity, sCGPA, sAge) Course ( cCode, cName,…

A: i. SELECT S.regNo, S.sName, S.sCity, S.sCGPA, S.sAge FROM Student AS S INNER JOIN Enrollment AS E ON…

Q: Using SQL-DDL Command, Convert the following schema to table in the DBMS. Make sure to make AcctNo…

A: In order to create table, we need to use CREATE TABLE COMMAND

Q: How do you write an sql for integrity constraints? What I have to solve is "Specify the integrity…

A: Constraints are rules of database that are followed to guard database against damages due to…

Q: Use %ROWTYPE for your cursor and use 3 tables in this activity - EMPLOYEES, JOBS, and DEPARTMENTS…

A: PL/SQL is a programming language that combines SQL with procedural capabilities. Oracle Corporation…

Q: Create a procedure in PL/SQL takes Department Id and return record data type has maximum salary,…

A: Find the required procedure in PL/SQL given as below :

Q: Using the output shown in Figure P7.12 as your guide, generate a list of customer purchases,…

A: Here we have to write an SQL query to have the given table/list of data in the fig. P7.12, Key…

Q: Use Column level constraint setting while designing the below given table in sql named as…

A: Column constraints: In Structured Query Language, the column level constraints are used to specify…

Q: Write pl /sql To display employee name and employee department name for each employees?

A: It is basically designed for managing data in a relational database management system(RDBMS).

Q: Using nested subqueries in SQL, find the names of all vehicle manufacturers who have plant locations…

A: Required SQL Query Is given below:

Q: Write a PL/SQL procedure to change the name of the project to “AL Dahariyah Projects” where place…

A: GIVEN: Write a PL/SQL procedure to change the name of the project to “AL Dahariyah Projects”where…

Q: Write the following inserts, deletes, or updates in SQL, using the universityschema. Insert every…

A: Explanation: In the below query, “insert, select, into, from and where” are the keywords used. The…

Q: Answer this question by using the following tables. Please. Create in PL/SQL a stored…

A: Solution: Create in PL/SQL a stored procedure called 'StudentsActivities' to display the list of…

Q: Question:1 Show all data from employee table where name should be in ascending and salary in…

A: 1)Show all data from employee table where name should be in ascending and salary in descending…

Q: Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: )…

A: Below is the required procedure:

Q: 1. Use Employees table a) To display First_Name, Salary and Department_id ofall the employees, whose…

A: 1. A) select First_name, Salary, Department_idfrom Employeeswhere Department_id IN(50,80)…

Q: Q1 Show all data from employee table where name should be in ascending and salary in descending…

A: Question 1 Ans : SELECT * FROM employee e ORDER BY e.name ASC, e.salary DESC; Question 2 Ans :…

Q: ery to Show how many indices in employee table and what are their names?

A: Program Approach: 1- In this query required group by clause and aggregate function. 2- With the…

Q: In the SQL Oracle Application, Within the Employees table, each manager_id is the manager of one or…

A: Answer: SELECT manager_id, job_id, SUM(salary) "total salary", GROUPING(manager_id),…

Q: Write a query to display the employee name and hire date for all employees in the same department as…

A: Task : Write the SQL query to find the data of all employee for the department = 'Blake'.

Q: Write down the SQL to show the average salary for each department together with its department name…

A: CODE: SELECT department_name, AVG(salary), COUNT(commission_pct) FROM departments JOIN employees…

Q: January

A: Here, there are 4 questions based on the Database Management System and should be solved by SQL…

Q: Using the Schema - data/statistics Write down the following SQL queries. Assume appropriate data…

A: Create appropriate tables and do the given SQL queries Note: Dear user, as per company policy we…

Q: Write sql code for Use derived tables and joins to create a list of players who have scored more…

A: Fielding Table is not given but it is mentioned to consider same as other table. So, we can join all…

Q: Write an appropriate SQL query to determine if there are any students that are not registered for…

A: Given: Write an appropriate SQL query to determine if there are any students that are not registered…

Q: How do I do this question in SQL command? Use the Oracle database employees table and CASE…

A: Given, Use the Oracle database employees table and CASE expression to decode the department id.…

Q: Write a PL/SQL using a cursor with Basic loop to update the Price attribute of all flight records in…

A: Since table name is not mentioned, I am assuming table name as flights The column names are FName,…

Q: Write a query to find, name, hire_date, phone_number, department name for the employees in HR…

A: oehr_departments and oehr_employees are connected by department_id and manager_id in both the tables…

Q: use sql developer to create a query for cursor.. cursor cur1 as SELECT e.first_name,…

A: The answer is given in the below step

Q: You have been asked to run a query using the CASE statement to analyze the quantity of shares data…

A: Attached Oracle Query below: select sum(B1) as "0-100", sum(B2) as "101-400", sum(B3) as "401-800",…

Q: From Oracle SQL Need the code. Task 3: In the NONCAT table, change the description of item ID DT12…

A: We want to change description of item ID DT12. New description is Dog Toy Gift Bonaza. He we used…

Q: From Oracle SQL Need Code Task 4: In the NONCAT table, increase the price of each item in category…

A: Please upvote me. I am providing you the correct answer below. I am taking certain assumptions…

Q: Consider the following tables: Branch1 PropertyForRent1 branchNo bCity propertyNo pCity BO03 Glasgow…

A: Given:

Q: Perform the following operation in sql for insertion, updating and deletion using the referential…

A: Four tables are created using the below table scripts. The table design it already taking the…

Concept explainers

Intermediate SQL Concepts

A query is a request for data or information from one or more database tables. This information could be presented in the form of pictorials, graphs, or complicated findings which helps in easy interpretation. Structured Query Language (SQL) is the most widely used programming language for retrieving and organizing data from relational databases. Collection of tables with rows and columns is referred to as a database. SQL is the language of databases. It makes it easier to extract specific data from databases, which can then be used for analysis.

Question

use EMP and DEPT tables, in the Live SQL, to perform the following operations.

List the Departments's Names that have no employees

solution:

select de.DNAME Department_Name, count(em.EMPNO) No_Of_Employees from SCOTT."EMP" em,SCOTT."DEPT" de where em.DEPTNO = de.DEPTNO group by de.DNAME;

i need it using NVL function.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Write the following queries in SQL: Display the list of all course sections offered in Spring 2018, along with the ID and name of each instructor teaching the section. If a section has more than one instructor, that section should appear as many times in the result as it has instructors. If a section does not have any instructor, it should still appear in the result with the instructor name set to “—”.
in pl/sql ,use Cursor to get all the records from table job_history for employee_id 121
In the SQL Oracle Application, Within the Employees table, each manager_id is the manager of one or more employees who each have a job_id and earn a salary. For each manager, what is the total salary earned by all of the employees within each job_id? Write a query to display the Manag-er_id, job_id, and total salary. Include in the result the subtotal salary for each manager and a grand total of all salaries
How can I remove the duplicates in SQL? Here is the code. SELECT [EmployeeID] ,[RoleID] ,Count(*) as '# of duplicates'FROM [dbo].[EmployeeRoles]Group by [EmployeeID] ,[RoleID]Having Count(*) > 1
Math in SQL -- Write your query here task #3 Using the retail.inventory table, pull the current stock percentage out of the future stock level for the product with a product_id = 21.
Using the output shown in Figure P7.12 as your guide, generate a list of customer purchases, including the subtotals for each of the invoice line numbers. The subtotal is a derived attribute calculated by multiplying LINE_UNITS by LINE_PRICE. Sort the output by customer code, invoice number, and product description. Be certain to use the column aliases as shown in the figure. In the SQL Query do the following Select clause: CUS_CODE, INV_NUMBER, P_DESCRIPT, LINE_UNITS AS “Units Bought”, LINE_PRICE as “Unit Price”, derived attribute Subtotal using the formula stated above From: Join conditions between these tables INVOICE, LINE, PRODUCT Where clause: You can put join conditions here as well if you do not want to put them in the from clause. There are many ways to write the query. Order by clause: use the columns as stated in the problem description.
Write SQL command that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each mode flied (based on the CHARTER table, name this Trip_Num), and Total distance of each mode (based on the CHARTER table, name this Total_Distance).
Write a PL/SQL using a cursor with Basic loop to update the Price attribute of all flight records inFlight table according to the following conditions: 1- If the FName is Oman Air, change price to 500.2-If the FName is Emirates, change price to 200.3- If the FName is Air India, change price to 250.
In the picture is my answer but it is incorrect, can anyone help? Using the data in the ASSIGNMENT table, write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked, sorted by employee number. The results of running that query are shown in Figure P7.6.
What is the query used to see if the date format is same and find values other than dates in the rows (In a large data with many rows) in SQL?
Write SQL Queries for following set of tables:EMPLOYEE (EmpNo, Name, DoB, Address, Gender, Salary, DNumber)DEPARTMENT (DNumber, Dname, ManagerEmpNo, MnagerStartDate).i) Display the Age of ‘male’ employees.ii) Display all employees in Department named ‘Marketing’.iii) Display the name of highest salary paid ‘female’ employee.iv) Which employee is oldest manger in company?v) Display the name of department of the employee ‘SMITH’..
Assuming all tables and columns exist, in which of the following SQL can the HAVING clause be written as a WHERE clause? SELECT a, count(*) FROM xyz GROUP BY a HAVING a = 34 SELECT a, count(*) FROM xyz GROUP BY a HAVING count(*) = 34 SELECT a, sum(c) FROM xyz GROUP BY b HAVING sum(c) < 0 SELECT c, min(a), max(b) FROM xyz GROUP BY c HAVING min(a) =max(b)