Manual

SALESMONTHSALES_REP
1400JuneCathy
600JuneJulie
1200JulyJohn
700JulyCathy
1000JulyJulie
MapInfo Professional could also compute the total sales for each representative by specifying in the
SQL Select dialog box:
• Select Columns: SALES_REP, sum(SALES)
• Group by Columns: SALES_REP
sum(SALES)SALES_REP
3300John
3000Cathy
2700Julie
or MapInfo Professional could compute the average sales for each representative:
• Select Columns: SALES_REP, avg(SALES)
• Group by Columns: SALES_REP
avg(SALES)SALES_REP
1100John
1000Cathy
900Julie
or MapInfo Professional could compute the total sales for each month:
• Select Columns: MONTH, sum(SALES)
• Group by Columns: MONTH
sum(SALES)MONTH
3200May
2900June
2900July
MapInfo Professional has six aggregate functions:
• Count(*): counts the number of records in a group. It takes * as its argument because it applies to the
record as a whole, and not to any particular field in the record.
• Sum (expression): calculates the sum of the values in <expression> for all group records.
MapInfo Professional 12.5252
Querying Your Data in MapInfo Professional