Question: Questions 1 - Do a Rollup operation on Table 1 , by country, name the result Table 2 . 2 - Do a slice operation
Questions Do a Rollup operation on Table by country, name the result Table Do a slice operation on Table to get sales in name the result Table Execute the operation on Table : Dice Country KSA OR Tunisia Year OR name the result Table Executetheoperation onTable: DicetownParisORJeddahORTunisYear OR name the result Table Do a Drill down operation on Table to get the sales by semester. We suppose that the semesters have equal sales, name the result Table Do the Pivot operation on the Table name the results table Exercise : Using Table or cube Write the following OLAP Queries: Q: : Get the total of sold cars by Town, and colour exp Paris for white cars Q: Get the total sold cars by country, year, and colour Q: Get the colours with the highest number of sold cars. Q: Get the country that account the highest number of sold cars
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
