Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases 11th British National Conference On Databases Bncod 11 Keele Uk July 7 9 1993 Proceedings Lncs 696

Authors: Michael F. Worboys ,Anna F. Grundy

1993rd Edition

3540569219, 978-3540569213

More Books

Students also viewed these Databases questions

Question

Match each equation with its graph in AD. 1 y=-x + 2 +2 4

Answered: 1 week ago

Question

Q.6 What is the content of smime.p7s file and How can I read it

Answered: 1 week ago