The following is a sample sales_tbl table:
SELECT city, state, region, quarter, amt, profit_margin FROM sales_tbl
ORDER BY city,state, region;
CITY | STATE | REGION | QUARTER | AMT | PROFIT_MARGIN
-------------+-------+-----------+---------+------+---------------
Atlanta | GA | Central | 4 | 1700 | 16
Atlanta | GA | Central | 2 | 1500 | 12
Atlanta | GA | Central | 3 | 1600 | 15
Atlanta | GA | Central | 1 | 1500 | 12
Baltimore | MD | Central | 2 | 2500 | 21
Baltimore | MD | Central | 3 | 2000 | 22
Baltimore | MD | Central | 4 | 2500 | 19
Baltimore | MD | Central | 1 | 2000 | 12
Boston | MA | Northeast | 1 | 2000 | 10
Boston | MA | Northeast | 2 | 1500 | 20
Boston | MA | Northeast | 3 | 1700 | 21
Boston | MA | Northeast | 4 | 2400 | 20
Los Angeles | CA | Southwest | 4 | 5300 | 22
Los Angeles | CA | Southwest | 2 | 3000 | 15
Los Angeles | CA | Southwest | 3 | 3500 | 17
Los Angeles | CA | Southwest | 1 | 3000 | 15
New York | NY | Northeast | 4 | 5000 | 20
New York | NY | Northeast | 1 | 3000 | 8
New York | NY | Northeast | 3 | 4300 | 22
New York | NY | Northeast | 2 | 3700 | 20
Seattle | WA | Northwest | 2 | 2200 | 15
Seattle | WA | Northwest | 4 | 2300 | 17
Seattle | WA | Northwest | 3 | 2200 | 18
Seattle | WA | Northwest | 1 | 2000 | 15
(24 rows)
IBM PureData System for Analytics, Version 7.1