Consider the following Data Warehouse tables: Specify in SQL and show the results of the following OLAP queries: Find total sales per city. Find total sales per state. Specify an SQL expression to perform the following roll up query: Given sales by cities get sales by states. Show the result of this query. Specify a linear algebra expression to perform the following drill down query: Given sales by states get sales by cities. Show the result of the drilling down using Least Squares Method Show a linear algebra expression and the result of the drilling down using an assumption that total sale in Los Angeles is twice as big as in San Francisco. Compute RMSE to for cases (b) and (c). Show the result of the drilling down using Least Squares Method Show a linear algebra expression and the result of the drilling down using an assumption that total sale in Los Angeles is twice as big as in San Francisco. Compute RMSE to for cases (b) and (c). Show the result of the dril