Clearly, we have a geographical hierarchy of the attributes of this table: region, st, city, and storeno. To study the total sales in each state we can use the following rollup query:
Clearly, we have a geographical hierarchy of the attributes of this table:region, st, city, and storeno. To study the total sales in each state we can usethe following rollup query: