|  A simple example to show how aggregation works in the IBL



the table has a row some-x some-y
--------------------------------------------------
there is a value that-x in column one of the table


the table has a row this-x this-y
=================================
                     aa    4
                     aa    5
                     bb    6
                     cc    6


sum some-y : the table has a row some-x some-y = some-z
-------------------------------------------------------
the total is that-z


avg some-y : the table has a row some-x some-y = some-z
-------------------------------------------------------
the avg is that-z


max some-y : the table has a row some-x some-y = some-z
-------------------------------------------------------
the max is that-z


min some-y : the table has a row some-x some-y = some-z
-------------------------------------------------------
the min is that-z


count some-y : the table has a row some-x some-y = some-z
---------------------------------------------------------------
the number of distinct items in column 2 of the table is that-z


count : the table has a row some-x some-y = some-z
--------------------------------------------------
the number of rows in the table is that-z


there is a value some-x in column one of the table
count some-y : the table has a row that-x some-y = some-z
-------------------------------------------------------------------------------
for col one value that-x the number of items in column 2 of the table is that-z


there is a value some-x in column one of the table
count : the table has a row that-x some-y = some-z
------------------------------------------------------------------
for col one value that-x the number of rows in the table is that-z


there is a value some-x in column one of the table
sum some-y : the table has a row some-x some-y = some-z
-------------------------------------------------------
the total for that-x is that-z