Answered step by step
Verified Expert Solution
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
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
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