Write a program that displays the number of students in each department in a pie chart and a bar chart, as shown in Figure 32.27b. The number of students for each department can be obtained from the Student table (see Figure 32.4) using the following SQL statement:

Transcribed Image Text:

select deptId, count(*) from Student where deptId is not null group by deptId;