Exercises Data warehouse OLAP: The following table, gathers the number of Sold cars: Questions 1- Do a Rollup operation on Table 1, by country, name the result Table 2. 2- Do a slice operation on Table 2, to get sales in 2018, name the result Table 3. 3. Execute the operation on Table 2: Dice (Country = KSA OR Tunisia , Year =2019OR2018 \#), name the result Table 4 . 4- Execute the operation on Table 2: Dice (town Paris OR Jeddah OR \& Tunis , Year 2019 OR 2018 ), name the result Table 5 . 5. Do a Drill down operation on Table 3 , to get the sales by semester. We suppose that the semesters have equal sales, name the result Table 6 . 6. Do the Pivot operation on the Table 3 , name the results table 6 . 7- Exercise 2: Using Table 1 (or cube), Write the following OLAP Queries: Q1: : Get the total of sold cars by Town, and colour (exp. Paris 350 for white cars) Q2: Get the total sold cars by country, year, and colour Q3: Get the 2 colours with the highest number of sold cars. Q4: Get the country that account the highest number of sold cars