Count number of faculty members by each department.
Write queries for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> SELECT DeptId, COUNT(*)
2 FROM faculty
3 GROUP BY DeptId;
DEPTID COUNT(*)
---------- ----------
1 2
2 2
3 2
4 1
5 1
```
Computer Science & Information Technology
You might also like to view...
In Twitter, Tweets are limited to 140 characters
Indicate whether the statement is true or false
Computer Science & Information Technology
The Group, Sort, and Total pane appears when the Group & Sort button is selected
Indicate whether the statement is true or false
Computer Science & Information Technology