Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on the star schema example studied in chapter 6 (cf. slide13), answer the following three questions. SQL Extensions to support OLAP queries: advanced AGGREGATE
Based on the star schema example studied in chapter 6 (cf. slide13), answer the following three questions. SQL Extensions to support OLAP queries: advanced AGGREGATE functions Consider the following star schema example Question 1 Write the proper SQL query to obtain the result illustrated in the table below. Note that all of these Quantity_rold are related to the moeth July of 2019. Question 2 We want to replace the aull values in columns "Chamel_Dese" and "CO" by respectively "Internet + Catalog", and "KSA+UAE". Write the SQL query to achieve this goal. 1 Question 3 Write a SQL. query to display two ranks hased on SUM(Quantity_sold) in a descending order. The first one will be within the following months: "2020-11", "2020)_10", "2000.9". The socood rank will be within the following countries: "KSA", "UAE", and "BH". Obvionsly, we would libe to have hoth ranks in the same result and query
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