Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started