PRODUCT CUSTOMER Product_ID Product Name Product Desc Product_Type Customer ID Customer_Name Customer_Desc Customer_Category SALES Product ID Customer ID Region_ID Time_ID Sales Profit REGION TIME Time ID Day Week Month Year Region_ID Street City Country Figure 1. A Sample Star Schema 1. Write a SQL statement to generate a 3 dimensional cube called CUBE1 that views Profits per State per, Product_Type, and per Month 2. Write a SQL statement to generate a 2 dimensional cube called CUBE2 directly from CUBE1. CUBE2 views Profits per State and per Product_Type 3. Convert the star schema to a snowflake schema by putting City, State, and Country in a separate dimension table called City. Please draw the resulting snowflake schema 4. Based on the generated snowflake schema, please write a SQL statement to create a cube that views Sales per Country, per Customer_Category, and per Year