Question

Which of the following SQL queries would return the total number of employees in each department, but only for departments with more than 10 employees?

Q: Answer-Which of the following SQL queries would return the total number of employees in each department, bu...

SELECT departmentid, COUNT FROM employees GROUP BY departmentid HAVING COUNT 10

A 'SELECT department_id, COUNT(*) FROM employees GROUP BY department_id HAVING COUNT(*) > 10;'

B 'SELECT department_id, COUNT(*) FROM employees WHERE COUNT(*) > 10 GROUP BY department_id;'

C 'SELECT department_id, COUNT(*) FROM employees GROUP BY department_id ORDER BY COUNT(*) > 10;'

D 'SELECT department_id, COUNT(*) FROM employees HAVING COUNT(*) > 10;'

E 'SELECT department_id, COUNT(*) FROM employees WHERE department_id IN (SELECT department_id FROM employees GROUP BY department_id HAVING COUNT(*) > 10);'

Practice Next

More IT DBMS Questions

In two-phase locking, a transaction releases its locks:
What is the output of the following pseudo-code? ``` count = 0 for i from 1 to 3: for j from 1 to i: count = count + 1 ...
A view in SQL is:
Which operation is NOT part of relational algebra?
An SQL `VIEW` is a:
In the Relational Database Model, data is organized into:
Which constraint ensures that no duplicate values exist in a column?
Which of the following database models represents data as a collection of tables, where each table consists of rows and columns?
Examine the following Java-like code: ```java class Parent { String name = "Parent"; public void display() { Syst...
Indexes improve query performance but can degrade performance of:

Hey! Ask a query

Which of the following SQL queries would return the total number of employees in each department, but only for departments with more than 10 employees?

Detailed Solution

More IT DBMS Questions

Hey! Ask a query

Please Register/Login