Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 8 3 pts For the following SQL query, which statement about measures and dimension attributes is true? SELECT store.store_address, SUM(sales.quantity) As quantity_sold FROM sales

image text in transcribed

Question 8 3 pts For the following SQL query, which statement about measures and dimension attributes is true? SELECT store.store_address, SUM(sales.quantity) As quantity_sold FROM sales INNER JOIN product ON sales.product_id = product.product_id INNER JOIN time ON sales.time_id = time.time_id INNER JOIN store ON sales.store_id = store.store_id WHERE time. action_year = 2016 AND store.city = 'Berlin' AND product.product_type = 'phone' GROUP BY store.store_id, store.store_address Osales.quantity and quantity_sold are measures and store.city is a dimension attribute. O time.action_year and sales. quantity are measure attributes and store.city is a dimension attribute. store.city is a non-additive measure and product.product_type is a dimension attribute. O sales.quantity is a measure attribute and store.city is a dimension attribute. O all of the above are true O none of the above are true

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

Step: 3

blur-text-image

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

Programming The Perl DBI Database Programming With Perl

Authors: Tim Bunce, Alligator Descartes

1st Edition

1565926994, 978-1565926998

More Books

Students also viewed these Databases questions

Question

1. Who should participate and how will participants be recruited?

Answered: 1 week ago