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

Which SQL command is used to retrieve data from a database?
Which type of DBMS model organizes data in tables with rows and columns?
A company needs to schedule a maximum number of meetings in a single conference room. Each meeting `i` has a start time `s_i` and an finish time `f_i`. Onc...
Shadow Paging avoids:
Query optimization heuristic that “pushes selections down” improves:
A column or set of columns that uniquely identifies each row in a table is called a:
Which concurrency anomaly is specific to phantom reads?
A data warehouse is primarily characterized by which of the following properties?
Given a relation R(A, B, C, D, E) and functional dependencies {A -> B, BC -> D, D -> E}. Which of the following is a candidate key for R?
In the context of computer networks, what is the primary function of a router?

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