All the exercises here work with an employee file (or database); this file identifies all employees by an employee number and lists basic personnel information.
The exercise has the department number as input, selects all records from that department, and then does the sum of the salary fields of those records. Finally, the average salary is displayed.
The exercises that follow are written in different languages, executed in different environments and with different data sources, but all cover the functionality just described. ...