List the Departments's Names that have no employees (EMP and DEPT tables) select NVL(COUNT(empno),0), count(em.EMPNO) No_Of_Employees from SCOTT."EMP" em,SCOTT."DEPT" de where em.DEPTNO = de.DEPTNO group by de.DNAME;

Q: How is the order in which attributes appear in a result table changed?

A: In Database, each and every table have some attribute and they are listed in the table with some…

Q: . If the Employees table contains a foreign key named dept_id, is it likely that the values in this…

A: Employee contains primary key of department as foreign key.  This means there is one to many…

Q: Write the correct relational algebra query for the below question: Assume that there are two tables…

A: An equi join is a type of join that combines tables based on matching values in specified columns.…

Q: Problem 7 Write a query to produce the total number of hours and charges for each of the projects…

A: Here you have simply used the ROUND(value,2) function. This will simply round the value to 2 places…

Q: encies that exist in the following table and then convert this table to an equivalent collection of…

A: A functional dependence is a constraint between two sets of attributes in a relation in a database…

Q: How many patients in the database have been diagnosed with acute bronchitis (ICD9Code = 466) and…

A: Count Query :- SELECT COUNT(column_name) FROM table_name WHERE condition; Groupby Query :-…

Q: Using the data in the ASSIGNMENT table, write the SQL code that will yield the total number of hours…

A: Here  Table Name is ASSIGNMENT and corresponding attributes need to find are EMP_NUM , EMP_LNAME,…

Q: The following table stores details of tutors, students and dates of lectures. The Primary Key is…

A: Rules regarding 2nd NF:-  tables must be in 1st NF.  No non-prime is functionally dependent on part…

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: Q1- List all employees whose job_id is IT_PROG and hired after 01-JAN-95 and earning more than 5000.…

A: Let the table name be emp which has the following columns   employee_id, first_name, last_name,…

Q: Convert the following table to third normal form (3NF). In this table, StudentNum determines…

A: Normalization can be defined in such a way that it is the system of organizing statistics in a…

Q: Write PL/SQL coomands for the following question 5. Table student(…

A: CREATE TABLE students AS SELECT name, age, inter_mark, entrance_rank, address, contact_no, ID,…

Q: Using the university schema, write an SQL query to find the names and IDs of those instructors who…

A: SQL queries are written to fetch records from databases that are composed of several relations.…

Q: Examine the table structure as given. SOL» DESC employees Name Null? Type - EMPLOYEE_ID NOT NULL…

A: The answer is

Q: Display the name of supplier(s) that supplied the most expensive computer?

A: we can't directly use aggregate functions in where clause. writing select columnName from tableName…

SQL Query

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed by using SQL.