Suppose that the fact table of Figure 17.1 has been cubed and the result has been stored as a view, Sales_v1. Design queries against Sales_v1 that will return the tables of Figure 17.10 and Figure 17.7.
What will be an ideal response?
SELECT S.Market_Id, S.Product_Id, S.Sales_Amt
FROM Sales_v1 S
WHERE S.Time_Id = NULL
Computer Science & Information Technology