This article provides an example to display total number of items ordered in each invoices.
selectcount(itemno) from invitem orderby itemno; Output: COUNT(ITEMNO) ------------- 5