Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 76 of 90

Querying Using SQL — Question 16

Back to all questions
16
Question

Question 16

List the count of employees grouped by deptno. (table EMPL)

Answer 
SELECT deptno, COUNT(*) AS employee_count
FROM EMPL
GROUP BY deptno;
Output
+--------+----------------+
| deptno | employee_count |
+--------+----------------+
|     20 |              5 |
|     30 |              6 |
|     10 |              3 |
+--------+----------------+