Design SQL queries for the supermarket example that will return the information needed to make a table similar to that of Figure 17.10, except that markets are aggregated by state, and time is aggregated by months.

a. Use CUBE or ROLLUP operators.
b. Do not use CUBE or ROLLUP operators.
c. Compute the result table.

a.

SELECT M.Region, T.month, SUM(S.Sales_Amt)

FROM Sales S, Market M, Time T

WHERE S.Market_Id = M.Market_Id AND S.Time_Id = T.Time_Id

GROUP BY CUBE (M.Region, T.month)



b.

SELECT M.Region, T.month, SUM(S.Sales_Amt)

FROM Sales S, Market M, Time T

WHERE S.Market_Id = M.Market_Id AND S.Time_Id = T.Time_Id

GROUP BY M.Region, T.month



SELECT M.Region, SUM(S.Sales_Amt)

FROM Sales S, Market M

WHERE S.Market_Id = M.Market_Id

GROUP BY M.Region



SELECT T.month, SUM(S.Sales_Amt)

FROM Sales S, Time T

WHERE S.Time_Id = T.Time_Id

GROUP BY T.month



SELECT SUM(S.Sales_Amt)

FROM Sales S





c.