...

<Add introduction for aggregate functions>

Creating a count-based query

<How to add aggregate functions>

<List down all the aggregate functions available>

...

<For each function add an example with expand macro>

Creating a count-based query

<How to add aggregate functions><How to remove the aggregate function>

Examples:

Example11 : Summarize protocols by participant, visit, and specimen counts.

Example22 : Find sum of available aliquot qty per parent specimen

Example33 : Find the latest transfer event for every specimen.

Example44 : Count of specimen, collected every quater per visit site.

...