Please see my other Database Development articles.

Performing division on integer values.

Often, recordsets contain values that naturally reveal metrics that provide helpful insight into the data.
In this example, I list records about people. Each record contains information about a person’s age, gender and name.

First, I list each person’s age, the sum of all peoples’ ages, then their age as a percentage compared against the total of all ages.

Here is the final resultset.